Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
Javier
 
Posts: n/a
Default Y-axe Multiscale charting

Hi all, I have to plot 4 series in an excel chat but the values between
series are too diferent to see it well.

Does anybody know how to plot it in a chart in some kind of multiscale Y-axe?

My values are

serie 1: 36-37-36-30-12-11
serie 2: 100345-134583-123908-290874-234986-13456
serie 3: 105-562-148-489-98-255
serie 4: 1.5-3.4-2.3-5.6-4.3-2.5

I only see well serie 2
Thanks in advance
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default Y-axe Multiscale charting

Hi,

Looks like you need to move the series 2 data to the secondary y axis.
Double click the series and choose Secondary axis on the Axis tab.

Cheers
Andy

Javier wrote:
Hi all, I have to plot 4 series in an excel chat but the values between
series are too diferent to see it well.

Does anybody know how to plot it in a chart in some kind of multiscale Y-axe?

My values are

serie 1: 36-37-36-30-12-11
serie 2: 100345-134583-123908-290874-234986-13456
serie 3: 105-562-148-489-98-255
serie 4: 1.5-3.4-2.3-5.6-4.3-2.5

I only see well serie 2
Thanks in advance


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
  #3   Report Post  
Posted to microsoft.public.excel.charting
James Silverton
 
Posts: n/a
Default Y-axe Multiscale charting

Javier wrote on Tue, 29 Nov 2005 07:30:04 -0800:

J Does anybody know how to plot it in a chart in some kind of
J multiscale Y-axe?

J My values are

J serie 1: 36-37-36-30-12-11
J serie 2: 100345-134583-123908-290874-234986-13456
J serie 3: 105-562-148-489-98-255
J serie 4: 1.5-3.4-2.3-5.6-4.3-2.5

A pretty good case for a logarithmic y-axis in a real graph
(scatter). I've tried you data and it works well.

James Silverton.

  #4   Report Post  
Posted to microsoft.public.excel.charting
Javier
 
Posts: n/a
Default Y-axe Multiscale charting

Thanks Andy, is there only secundary y axis, nor third or fourth y axis?

"Andy Pope" wrote:

Hi,

Looks like you need to move the series 2 data to the secondary y axis.
Double click the series and choose Secondary axis on the Axis tab.

Cheers
Andy

Javier wrote:
Hi all, I have to plot 4 series in an excel chat but the values between
series are too diferent to see it well.

Does anybody know how to plot it in a chart in some kind of multiscale Y-axe?

My values are

serie 1: 36-37-36-30-12-11
serie 2: 100345-134583-123908-290874-234986-13456
serie 3: 105-562-148-489-98-255
serie 4: 1.5-3.4-2.3-5.6-4.3-2.5

I only see well serie 2
Thanks in advance


--

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

  #5   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default Y-axe Multiscale charting

Hi,

If you don't mind a little construction work Jon Peltier explains how to
add additional y axis.
http://peltiertech.com/Excel/Charts/TertiaryAxis.html

Cheers
Andy

Javier wrote:
Thanks Andy, is there only secundary y axis, nor third or fourth y axis?

"Andy Pope" wrote:


Hi,

Looks like you need to move the series 2 data to the secondary y axis.
Double click the series and choose Secondary axis on the Axis tab.

Cheers
Andy

Javier wrote:

Hi all, I have to plot 4 series in an excel chat but the values between
series are too diferent to see it well.

Does anybody know how to plot it in a chart in some kind of multiscale Y-axe?

My values are

serie 1: 36-37-36-30-12-11
serie 2: 100345-134583-123908-290874-234986-13456
serie 3: 105-562-148-489-98-255
serie 4: 1.5-3.4-2.3-5.6-4.3-2.5

I only see well serie 2
Thanks in advance


--

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


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
training for Pivot Charting in Excel 2000 NaNa at HCMC Excel Discussion (Misc queries) 1 April 19th 05 09:58 PM
Program line when charting variances? Greg Strong Charts and Charting in Excel 3 March 27th 05 01:23 AM
Custom charting - Stacked charting with a line Randy Lefferts Charts and Charting in Excel 3 March 3rd 05 04:10 AM
Dynamic charting problems (events) [email protected] Charts and Charting in Excel 4 January 27th 05 10:32 PM
Charting time? help please... Gustavo Monteverde Charts and Charting in Excel 1 November 28th 04 05:53 AM


All times are GMT +1. The time now is 07:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"