Need Multiple Axes in Excel 2007 Scatter Chart 3

[MattGreer]

I have time-based data that I'm trying to show to folks. Data was taken from a chemical plant over time. There are about six different values that I want to show, but the ranges for each of these values are drastically different. Some range between one and ten, some between zero and 400, and some between 0 and 1. Excel seems to only have primary and secondary axes available.

Does anyone know of a way to get more than 2 Y axes on the same chart?


Thanks!!


Matt

 

[SkipVought]

hi,

How would that work? Where would the TERTIARY axis go? Well, right next to the SECONDARY axis, I guess. Yours is as good as mine.

So you must FOOL your audience, by plotting the data for the TERITARY axis in a totally separate chart and then superimposing one chart over the other, to make it appear to be ONE CHART with three axes. But that might distort the x-axis. You're gonna have to play with it.

BTW, I am working a project that has FIVE superimposed charts: A PIE at the center and three donuts with ever increasing holes around the pie to make what we call, a Schedule Wheel.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[xlhelp]

A third axis is virtually impossible. I say virtually, because there are some convulated ways to create multiple data values and create a pivot chart from these.

What you want to do can be done using a panel chart; sort of three charts in one.

Canadian eh! Check out the new social forum Tek-Tips in Canada.
I should live a long time - I eat a lot of preservatives.

 

[GlennUK]

I don't know if this is any use to you, but have a look anyway:

http://www.andypope.info/charts/3drotate.htm

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[SkipVought]

The OP was not really asking for 3 axes, but more than 2, which I interpreted as a scaling issue and not a 3-dimensional issue.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[lionelhill]

seriously recommend bursting into 3rd party non-office software if you do much of this sort of thing. I've used SigmaPlot (which is very Excel-friendly), but no doubt there are lots of others available.

I've never seen an out-of-the-box solution to six wildly different y-axes, but Sigmaplot is much more flexible than Excel, so it's less work to fool it into doing as Skip suggested.

 

[Gruuuu]

Or, why not scale your different data points to match another range, and add axis labels to match it?

I was going to create an example but it is a lot of work.
Plus this guy did a pretty good job.

http://peltiertech.com/Excel/Charts/BrokenYAxis.html

 

[MattGreer]

These are all good suggestions.

Regarding the first, Skip, essentially what you're talking about is taking two charts and dragging one over the top of the other?

I'll check out SigmaPlot, and Gruuuuu has a reasonable suggestion too. Thanks.

Thanks!!


Matt

 

[SkipVought]

Yes, and to do that properly, it oftne takes VBA code to get the desired alignment and coordination between axes limits so that the ZERO on each axis is aligned.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}