suggestions for how to plot the data?

**Helen_88** · 03-14-2009, 11:42 AM

Hello All,
Is it possible to chart the below dataset in Excel and if so san someone please provide suggestions for how to plot the data? Everything that I've tried so far just does not look right.
Thank you,
Helen

**Andy Pope** · 03-14-2009, 11:49 AM

What are you trying to show with a chart?

**Helen_88** · 03-14-2009, 12:33 PM

Thank you for your quick response....

For each of the categories that are listed horizontally (Rate, Growth, & Issued) I need to represent each value listed. E.G. for the category Rate “>0 to <1.3” and the category Growth “0” I need to reflect each value from the twelve Issued columns. (“Null”, “0”, “1”, etc, etc…) I need to do that for the entire matrix. Does that make sense?

**Andy Pope** · 03-14-2009, 01:17 PM

You have 2 problems here. One is the 3 dimensions for the chart and the other is the distorting nature of the 'Rate 0'/Growth '0' set of data which is massive compared to the other series.

One possibilty is to use a panel chart.
http://peltiertech.com/Excel/ChartsH...venScales.html

**Helen_88** · 03-14-2009, 02:42 PM

Thank you for your suggestion.

The 'Rate 0'/Growth '0' definitely is an issue. In the attachment I plotted the data using a 3D chart and you can see how the chart is distorted by this data point.

I read through the instructions for the panel chart, but as a novice Excel chart user I'm having a difficult time grasping how to apply the panel chart to my dataset.

Do you have any other recommendations?

Thanks again,
Helen

**Andy Pope** · 03-15-2009, 07:33 AM

Here is the start of the panel chart. Is this something you can work with?

**Helen_88** · 03-17-2009, 09:33 PM

Thank you for your response and your help! I’m letting it all soak in, which is going to take a while and a little more exploring on my end …..this is a little above my skill level