PC Review


Reply
Thread Tools Rate Thread

Chart with 4 different axis ?

 
 
H.G. Lamy
Guest
Posts: n/a
 
      29th Jan 2010
Hello,

for a particular analysis I would like to use all 4 axis with different
label (scales).
Is that feasable, and if so, how can I tackle the task? Thank you in
advance!

Kind regards,

H.G. Lamy


 
Reply With Quote
 
 
 
 
Mike Middleton
Guest
Posts: n/a
 
      29th Jan 2010
H.G. Lamy -

Create a chart with two or more data series. Select one data series and use
Format Axis to change it to secondary axis. If necessary, use Chart Options
to display all axes. Format each axis, paying attention to Patterns tick
mark and label locations and to Scale max, min, and crosses at.

For more specific instructions, specify your version of Excel.

An example ChartWithFourDifferentAxes, created using Excel 2003 SP3, is
available at http://www.MikeMiddleton.com.

- Mike



"H.G. Lamy" <(E-Mail Removed)> wrote in message
news:#(E-Mail Removed)...
Hello,

for a particular analysis I would like to use all 4 axis with different
label (scales).
Is that feasable, and if so, how can I tackle the task? Thank you in
advance!

Kind regards,

H.G. Lamy

 
Reply With Quote
 
H.G. Lamy
Guest
Posts: n/a
 
      1st Feb 2010
I start to get to grips with it, slowly.
Thank you, Mike.
Regards,
hgl

"Mike Middleton" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> H.G. Lamy -
>
> Create a chart with two or more data series. Select one data series and
> use
> Format Axis to change it to secondary axis. If necessary, use Chart
> Options
> to display all axes. Format each axis, paying attention to Patterns tick
> mark and label locations and to Scale max, min, and crosses at.
>
> For more specific instructions, specify your version of Excel.
>
> An example ChartWithFourDifferentAxes, created using Excel 2003 SP3, is
> available at http://www.MikeMiddleton.com.
>
> - Mike
>
>
>
> "H.G. Lamy" <(E-Mail Removed)> wrote in message
> news:#(E-Mail Removed)...
> Hello,
>
> for a particular analysis I would like to use all 4 axis with different
> label (scales).
> Is that feasable, and if so, how can I tackle the task? Thank you in
> advance!
>
> Kind regards,
>
> H.G. Lamy
>



 
Reply With Quote
 
 
 
Reply

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to manually switch data from x axis to y axis in line chart? scs.hq1 Microsoft Excel Charting 1 25th Jan 2008 02:56 AM
TO CREATE A LINE CHART WITH RATE IN Y AXIS & REAL TIME IN X AXIS =?Utf-8?B?dmlqYWljYmU=?= Microsoft Excel Charting 4 9th Nov 2006 10:16 AM
How to place a secondary y axis bar in a bar chart next to two primary y axis bars? Dmitry Microsoft Excel Discussion 1 4th May 2006 01:58 AM
How to place a secondary y axis bar in a bar chart next to two primary y axis bars? Dmitry Microsoft Excel Misc 3 4th May 2006 01:58 AM
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis mw210461@yahoo.com Microsoft Excel Charting 0 13th Jul 2005 09:30 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:57 PM.