stacking graphs

  • Thread starter Thread starter mark
  • Start date Start date
M

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?
 
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?
Click to expand...

--

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
 
Back
Top