View Full Version : Chart Help!!


lukea51
07-01-2008, 11:32 AM
I attached a picture of a chart that I'm trying to create. I manually created this chart using Microsoft expression design.

Is it possible to create this chart in excel?

Call_Me_Sam
07-01-2008, 03:28 PM
I attached a picture of a chart that I'm trying to create. I manually created this chart using Microsoft expression design.

Is it possible to create this chart in excel?

I can't actually see anyway of doing the forth 'piled up' column. i have tried a hash up of laying two charts one on top of the other..but it's a mess and won't line up..you prob tried that yourself..

shades
07-01-2008, 05:50 PM
John Walkenbach has some samples in his book Excel Charts, chapters 7 and 8. You might want to look there.

shades
07-02-2008, 07:35 AM
I checked in that book I mentioned in the post above. If you look at pages 256-257 and modify the setup you will get exactly what you want. I had setup something like that about a year ago. Note, rather than use blanks for no data in those columns that have only one stack, it would be better to use =NA() to produce #N/A which will not be plotted.