Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 2 of 2

Thread: combine a stacked and a normal histogram

  1. #1
    Join Date
    14th September 2004
    Location
    Surrey, England
    Posts
    802

    combine a stacked and a normal histogram

    Hello,

    I have three series that I would like to plot on the same chart.

    I would like to plot series 1 as a single column for each value.

    I would then like to plot series 2 with series 3 stacked on top alongside series 1.

    Is this possible?

    Thanks,

    Alan.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    14th September 2004
    Location
    Surrey, England
    Posts
    802

    Re: combine a stacked and a normal histogram

    Solution!

    Plot the first series on the primary x-axis and the others on the secondary x-axis. Use a dummy series on the primary axis to force series 1 to plot on the left of each y axis point.

    Play around with the gap width of the series plotted on each axis and it looks ok!

    Thanks for anyone who started to think about it.

    A.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Histogram Function
    By izzedgokalp in forum EXCEL HELP
    Replies: 3
    Last Post: November 22nd, 2006, 07:10
  2. Histogram Intervals
    By TomBP in forum EXCEL HELP
    Replies: 4
    Last Post: October 6th, 2006, 18:45
  3. Histogram: Intervals Below Bar
    By TomBP in forum EXCEL HELP
    Replies: 3
    Last Post: October 6th, 2006, 05:21
  4. Creating histogram from VBA
    By leonard in forum EXCEL HELP
    Replies: 4
    Last Post: April 26th, 2006, 08:05
  5. Histogram Suggestions
    By jason_sf in forum EXCEL HELP
    Replies: 4
    Last Post: May 7th, 2003, 02:22

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno