adding data to 1 column in a 2 column chart

[jeff]

Hi,

Why not pick "stacked column" as your chart type, with
the multi-valued column working ok, and substitute
zeros for the other column?

Somewhat like this:

ABC DEF
100 125
125
130
120
140
200
150
123

the stacked column ABC will show segments, while DEF
will only show one value (Make sure on the data range
tab, the series in: "rows" option is checked

jeff

-----Original Message-----
I have a 2 column chart and one bar is a sum of 10

components. How do I get that one column bar to show 10
segments when the other column bar remains one color?

 

[Jon Peltier]

This URL has links to a few pages that might help:

http://peltiertech.com/Excel/ChartsHowTo/ClusterStack.html

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