Results 1 to 5 of 5

Floating Bar, Min-Max, and specific data points

Threaded View

  1. #1
    Registered User
    Join Date
    12-07-2009
    Location
    Indiana
    MS-Off Ver
    Excel 2003
    Posts
    3

    Floating Bar, Min-Max, and specific data points

    Hi everyone. I've been asked to put together a chart, and it's been baffling me for the past week exactly how to get it the way my boss needs it done.

    I need to put together a floating bar chart that shows not just the min-max of each series, but discreet data points as well. The min-max isn't a problem, but getting all of the data points has not yet worked.

    I'm wondering if there is a way to combine charts and perhaps show a line with the data points beneath each min-max bar? Seems unlikely, as I've never seen a combo chart like that before.

    See attachment. It's dummy data, the actual charts will be MUCH larger (as many as 30 categories down the x-axis). And I realize I'd have to change the data to show variance to get the min-max to work probably. The original data isn't in an easy table like this either, I'll probably have to use some formulas to move it around. Plus it'll have to be automated when additional data is added later.

    Much thanks for any ideas or help!
    Attached Images Attached Images
    Last edited by Thumper76; 12-09-2009 at 01:26 PM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1