stacking graphs

[mark]

i want to analyze the relationship between 10 factors
over time. most of the factors have different
measurements or scales, such as milliseconds, pounds,
bar, percentage of 1, etc. As far as I can tell, Excel
charts can only deal with 2 different scales on the 2 Y
axes. does anyone know of a software add-in or program
that would allow me to stack a number of charts
vertically, while each uses the same scale (such as
seconds) on the horizontal X axis?

 

[Andy Pope]

Hi mark,

I don't know of anything that will do this automatically.
Maybe your best bet is to create a chart with a single data series.
Copy this 9 times and change the data source for each chart, long winded
I know. But if this is not a one off you could use VBA to make the
process easier.

i want to analyze the relationship between 10 factors
over time. most of the factors have different
measurements or scales, such as milliseconds, pounds,
bar, percentage of 1, etc. As far as I can tell, Excel
charts can only deal with 2 different scales on the 2 Y
axes. does anyone know of a software add-in or program
that would allow me to stack a number of charts
vertically, while each uses the same scale (such as
seconds) on the horizontal X axis?

--

Cheers
Andy

http://www.andypope.info

 

[Tushar Mehta]

[This followup was posted to microsoft.public.excel.charting with an
email copy to mark.
Please use the newsgroup for further discussion.]

Check a just-completed tutorial Excel | Tutorials | 'Stacked Charts' on
my web site.

--
Trouble finding replies to your posts? Use a newsreader. See the
tutorial 'Outlook Express and Newsgroups' on my web site

Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Jon Peltier]

Mark -

I show how to make a tertiary axis on a chart on this page:

http://www.geocities.com/jonpeltier/Excel/Charts/TertiaryAxis.html

It's a little work, and if you add too many it will make for a cluttered
chart. But it might give you what you need.

- Jon

 

[Jon Peltier]

Mark -

On rereading your post, I realize this example might be more like what
you want:

http://www.geocities.com/jonpeltier/Excel/Charts/StackedCharts.html

- Jon