'Different' kind of Stack-up chart

C

chiuinggum

I would like to plot a stack-up chart.
Country Model Volume
US A 2000
US B 3000
US C 1000
China X 2000
China Y 1000
China Z 5000

The X-axis show the country, Y axis – model/volume
 
J

Jon Peltier

I THINK this is what you want:

Arrange the data like this:

A B C X Y Z

US 2000 3000 1000

China 2000 1000 5000



create a stacked column chart, with series in columns.


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

change chart column colors 1
Help with Bar-Line Chart..not aligned?? 1
Doughnut Chart linked with the slicer in the pivot table 0
A line chart 3
Using OWC create Stack chart 0
Change Chart Properties for Multiple Chart Shts using a Worksheet 0
Consolidate my data and plot on a dual axis chart 3
How do I plot multiple LINES vs a Y Axis on a BAR Chart ? 4

Top