PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Charting Line - column on 2 axes

Reply

Line - column on 2 axes
 
Thread Tools Rate Thread
Old 10-03-2008, 12:50 PM   #1
TaraS
Guest
 
Posts: n/a
Default Line - column on 2 axes


How can I get the 2 different axis to equal zero at the same point without
laborously playing with the min, max, major, minor scales for each of my
graphs?
  Reply With Quote
Old 10-03-2008, 01:00 PM   #2
Andy Pope
Guest
 
Posts: n/a
Default Re: Line - column on 2 axes
Hi,

Have a look at Jon's VBA solution.
http://peltiertech.com/Excel/Charts/AlignXon2Ys.html

Cheers
Andy

TaraS wrote:
> How can I get the 2 different axis to equal zero at the same point without
> laborously playing with the min, max, major, minor scales for each of my
> graphs?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
  Reply With Quote
Reply

Archive


Thread Tools
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
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off