Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Create a combo chart with two of the same chart types
I'd like to create a combo chart to compare "plan" and "actual" figures over
several years. I'd like to use 3-D Columns, but I'd like to indicate the components within each plan and actual figure, in a stacked 3-D column. I think what I'd like is a combo chart, with one 3-D column chart for plans figures, and a second 3-D column chart for actuals. Can I create a combo chart where both chart are the same chart type? |
#2
|
|||
|
|||
I'd like to create a combo chart to compare "plan" and "actual" figures over
several years. I'd like to use 3-D Columns, but I'd like to indicate the components within each plan and actual figure, in a stacked 3-D column. I think what I'd like is a combo chart, with one 3-D column chart for plans figures, and a second 3-D column chart for actuals. Can I create a combo chart where both chart are the same chart type? If you use the non-3D stacked bar chart, you can put your plan and actual data series each on a separate Y axes (not sure why, but this option doesn't seem to work for the 3D stacked chart). Unfortunately the one set of data will sit on top of the other and obscure it so this doesn't work very well. I thought this might be easy to fix by specifying odd numbers as the category (x) values for one set of data and the even numbers for the other set, unfortunately it doesn't seem to be possible to specify a different category formula for the different series. Probably your best solution is to create two separate charts and overlay one on top of the other, offsetting one slightly so that the data doesn't overlap. |
#3
|
|||
|
|||
If we're not insisting on 3D charts (which are not particularly flexible
or capable), this example shows how to use primary and secondary axes with column charts: http://peltiertech.com/Excel/Charts/...OnTwoAxes.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Phil Preen wrote: I'd like to create a combo chart to compare "plan" and "actual" figures over several years. I'd like to use 3-D Columns, but I'd like to indicate the components within each plan and actual figure, in a stacked 3-D column. I think what I'd like is a combo chart, with one 3-D column chart for plans figures, and a second 3-D column chart for actuals. Can I create a combo chart where both chart are the same chart type? If you use the non-3D stacked bar chart, you can put your plan and actual data series each on a separate Y axes (not sure why, but this option doesn't seem to work for the 3D stacked chart). Unfortunately the one set of data will sit on top of the other and obscure it so this doesn't work very well. I thought this might be easy to fix by specifying odd numbers as the category (x) values for one set of data and the even numbers for the other set, unfortunately it doesn't seem to be possible to specify a different category formula for the different series. Probably your best solution is to create two separate charts and overlay one on top of the other, offsetting one slightly so that the data doesn't overlap. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create a chart in excel with data from another workbook | Charts and Charting in Excel | |||
How to create a line chart with two X-axes in Excel | Excel Discussion (Misc queries) | |||
combo chart | Charts and Charting in Excel | |||
how do I create a cluster chart? | Charts and Charting in Excel | |||
How do I create a pointer chart, like a speedometer? | Charts and Charting in Excel |