If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
superimposed 3-D stacked area charts
Hello,
I want to show two stacked area charts side by side in one 3-D display. X axis = years. Y axis = $. Data set #1 has national advertising and national promotions, which I want stacked together. Data set #2 has local advertising and local promotions, which I want stacked together, but separately from Data Set #1. The values in Data set #1 are always larger than those in set #2 for a given year, so #1 can go in the back of the 3-D chart area, with the smaller set in the front. Now I am creating two charts, setting the axes the same, blanking the chart fill, and pasting one over the other. It works, but changing the data is a pain. I appreciate any guidance on this. |
#2
|
|||
|
|||
superimposed 3-D stacked area charts
You're killing yourself to make a chart which is difficult to interpret.
3D charts are popular, but cognitive scientists and charting experts have shown that people have trouble judging relative values in 3D charts. It is possible to make a 2D chart that shows clusters of stacked bars. You only need to arrange your data properly. I've written a tutorial on the technique: Clustered-Stacked Column Charts http://peltiertech.com/WordPress/clu...column-charts/ - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ Colby wrote: Hello, I want to show two stacked area charts side by side in one 3-D display. X axis = years. Y axis = $. Data set #1 has national advertising and national promotions, which I want stacked together. Data set #2 has local advertising and local promotions, which I want stacked together, but separately from Data Set #1. The values in Data set #1 are always larger than those in set #2 for a given year, so #1 can go in the back of the 3-D chart area, with the smaller set in the front. Now I am creating two charts, setting the axes the same, blanking the chart fill, and pasting one over the other. It works, but changing the data is a pain. I appreciate any guidance on this. |
#3
|
|||
|
|||
superimposed 3-D stacked area charts
OK, Jon, thanks for your advice and time -- I'll try it that way.
"Jon Peltier" wrote: You're killing yourself to make a chart which is difficult to interpret. 3D charts are popular, but cognitive scientists and charting experts have shown that people have trouble judging relative values in 3D charts. It is possible to make a 2D chart that shows clusters of stacked bars. You only need to arrange your data properly. I've written a tutorial on the technique: Clustered-Stacked Column Charts http://peltiertech.com/WordPress/clu...column-charts/ - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ Colby wrote: Hello, I want to show two stacked area charts side by side in one 3-D display. X axis = years. Y axis = $. Data set #1 has national advertising and national promotions, which I want stacked together. Data set #2 has local advertising and local promotions, which I want stacked together, but separately from Data Set #1. The values in Data set #1 are always larger than those in set #2 for a given year, so #1 can go in the back of the 3-D chart area, with the smaller set in the front. Now I am creating two charts, setting the axes the same, blanking the chart fill, and pasting one over the other. It works, but changing the data is a pain. I appreciate any guidance on this. |
Thread Tools | |
Display Modes | |
|
|