Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chart: Need idea to display (Z axis)
I have data that is ideal for a column chart. There are 10 countries and the
market share %'s for Pepsi and Coke for each country. However, I also have the growth rates for each country. I wanted to add the volumn growth to Z axis of a 3D chart but don't know how to do? Any suggestion appreciated. Market Share (1995) Top 10 Markets Volume Growth (1994 - 1995) Coca-Cola Pepsi-Cola United States 2 43 31 Mexico 1 61 21 Japan 10 34 5 Brazil 55 51 10 East-Central Europe 0 40 21 Germany -2 56 5 Canada 2 37 34 Middle East 0 23 38 China 0 20 10 United Kingdom 12 32 12 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chart: Need idea to display (Z axis)
The best way to do this would be to create a second chart for growth rates.
Even if Excel were any good at plotting data on a "Z" axis, it's very difficult to format such a chart so it is comprehensible. A second approach would be to add the data to the market share column chart (copy the range, select the chart, edit menu paste special as new series) then change the added series to a line chart type (chart menu Chart type), and if necessary assign this series to the secondary axis (double click axis tab). - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "denton" wrote in message ... I have data that is ideal for a column chart. There are 10 countries and the market share %'s for Pepsi and Coke for each country. However, I also have the growth rates for each country. I wanted to add the volumn growth to Z axis of a 3D chart but don't know how to do? Any suggestion appreciated. Market Share (1995) Top 10 Markets Volume Growth (1994 - 1995) Coca-Cola Pepsi-Cola United States 2 43 31 Mexico 1 61 21 Japan 10 34 5 Brazil 55 51 10 East-Central Europe 0 40 21 Germany -2 56 5 Canada 2 37 34 Middle East 0 23 38 China 0 20 10 United Kingdom 12 32 12 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add vertical lines to a line chart (already has 2 Y axis) | Charts and Charting in Excel | |||
How do I display columns side-by-side in a two Y axis chart? | Charts and Charting in Excel | |||
Secondary Axis chart | Charts and Charting in Excel | |||
Stacked Bar Chart with Secondary Axis | Charts and Charting in Excel | |||
Scatter Chart Axis as text in C# Web appl | Charts and Charting in Excel |