Can I set 2 charts to have the same Y axis?

D

David Thielen

I know I can hardcode the min/max for the Y axis on two charts to
match. But I have a case where we have data coming in that can be very
different week from week.

Is there a way to tell Excel to calculate the min/max for the Y axis
on two charts - but to use the combined data from both when
calculating so the two sharts will get the same min/max?

And of so - how?

thanks - dave

david@[email protected]
Windward Reports -- http://www.WindwardReports.com
me -- http://dave.thielen.com

Cubicle Wars - http://www.windwardreports.com/film.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chart questions 4
How can I set the ShapeRange.WrapFormat? 2
ShapeRange.ZOrderPosition - how do I set it? 2
How can I determine if a Shape is in front of or behind the document? 8
ContentControl Tag & Title are limited to 64 chars - where can I store very long strings? 8
(Inline)Shape - how do I change the bitmap itself? 2
How can I be the data provider for a chart? 5
How do I get the padding of a Shape? 1

Top