Chart Type

[Jay Gustafson]

Hello,

I am having trouble finding the specific chart I need. I have two series
I'm charting.

Total Issues: 200
Total Issues over 30 days: 100

On my chart, what I want is a bar, the first series would show up to 200,
then the second series would show at 100, but it would be overlayed. So
when you looked at it, half of it was another color cause that's another
series.

But what the chart is doing is, it's showing 200 & 100 ontop of each other,
which is bringing it to 300.

Does that make sense? I can't figure out what chart I should be using.
I've tried many so far and nothing is going me the results I'm looking for.

Thanks,
Jay

 

[Jon Peltier]

Jay -

A stacked chart begins each series where the previous one ended, so
you've just plotted 100+200=300. Make a clustered column chart, double
click on either series, and on the Options tab, change the Overlap to
100. What will you do when the tall one is in front of the short one?
You could try an overlap between 0 and 100 to see how that looks.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Jay Gustafson]

Jon,

Thank you for helping me with my question. Your suggestion worked perfectly. I changed the 'order' of the series, so the smaller number was upfront at all times. 99.99% of the time the large number will always be larger than the smaller number. Once there is a case where the larger number does fall short, I will change the overlapping.

Thank you again!
Jay Gustafson