stacking graphs

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?

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.

mark wrote:

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

[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

In article , lotuselan_91
@yahoo.com says...
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?

Mark -

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

http://www.geocities.com/jonpeltier/...tiaryAxis.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, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

mark wrote:
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?

Mark -

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

http://www.geocities.com/jonpeltier/...kedCharts.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Jon Peltier wrote:
Mark -

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

http://www.geocities.com/jonpeltier/...tiaryAxis.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, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

mark wrote:

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?