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

David Thielen

Guest

Posts: n/a

28th Apr 2010

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@at-at-(E-Mail Removed)
Windward Reports -- http://www.WindwardReports.com
me -- http://dave.thielen.com

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

« Why would the same chart appear different to two users? | Creating a total cost chart where a component cost is a step cost »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
3-axis charts	GStolz	Microsoft Excel Misc	6	10th Apr 2009 08:21 PM
y-axis versus x-axis charts	=?Utf-8?B?YmlnZXNpbW0=?=	Microsoft Excel Charting	1	27th Sep 2007 03:14 AM
Charts on 2 axis'	=?Utf-8?B?c3RuZWxzb24=?=	Microsoft Excel Charting	1	6th Jun 2007 05:18 AM
charts....x and y axis	=?Utf-8?B?SGF6ZXVz?=	Microsoft Excel Charting	5	12th Mar 2005 04:19 AM
Hiding Values Below Z Axis Minimum Value on Axis Charts	=?Utf-8?B?VHJ5aW5nVG9FeGNlbA==?=	Microsoft Excel Charting	1	18th Feb 2005 03:55 AM