ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I create a 4-d chart? (https://www.excelbanter.com/charts-charting-excel/95763-how-do-i-create-4-d-chart.html)

evanr

How do I create a 4-d chart?
 
I am trying to create a chart with 4 dimensions. In effect, I need a 3-D
column chart where the vertical bars are "stacked" colmns. How can I do this?

Kelly O'Day

How do I create a 4-d chart?
 
Evanr

Have you heard about Tufte's "small multiples" or Cleveland's "trellis"
displays? These approaches create a series of small plots instead of trying
to put everything into a single overly complex chart. I would stay away form
3D charts in Excel.

Trellis is a trademarked by Insightful software. I use the term "panel
charts" to reflect trellis and small multiple charts in Excel. I have
examples of horizontal and vertical panel charts at this link which may
help you see another way to visualize your data.

http://processtrends.com/toc_panel_charts.htm

Jon Peltier has an example of stacked charts which is similar to my vertical
panel chart example.

http://peltiertech.com/Excel/Charts/axes.html#StakCht

Andy Pope has a two-way mini-plot example.
http://www.andypope.info/charts/miniplot_xy.htm

These should get you started.

...Kelly




"evanr" wrote in message
...
I am trying to create a chart with 4 dimensions. In effect, I need a 3-D
column chart where the vertical bars are "stacked" colmns. How can I do
this?





All times are GMT +1. The time now is 10:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com