| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I mix column chart types?
I would like to create a column chart where each x-axis point (date) has 2
columns, one for forecast and one for actual, but I would like to subdivide the "actual" bar into 3 separate sections. Any ideas?? I have tried pivoting and such, but to no avail. Thanks. |
|
#2
|
|||
|
|||
|
It's all about arranging the data:
http://peltiertech.com/Excel/ChartsH...sterStack.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Ramesh Narasimhan wrote: I would like to create a column chart where each x-axis point (date) has 2 columns, one for forecast and one for actual, but I would like to subdivide the "actual" bar into 3 separate sections. Any ideas?? I have tried pivoting and such, but to no avail. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| match and count words | Excel Worksheet Functions | |||
| Column Chart | Charts and Charting in Excel | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
| Making Special "Stacked Column" Chart | Charts and Charting in Excel | |||
| Copying the contents of a column into a chart | Excel Worksheet Functions | |||
Linear Mode
