Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default 2 scales in 1 chart

Hi,

I'm using xl'97 and I'm trying to chart 2 different tables to 1 chart.
To do this I would need XL to display 1 scale on left and another one
on right sided of the chart and then chart both tables to 1 chart.

Is this possible ?

Thanks for help,
Sirritys

  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1,071
Default 2 scales in 1 chart

Plot both series on the chart. Then, double-click the series you want on
the secondary (right) axis, and in the resulting dialog box, from the Axis
tab, select 'Secondary'.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article .com,
says...
Hi,

I'm using xl'97 and I'm trying to chart 2 different tables to 1 chart.
To do this I would need XL to display 1 scale on left and another one
on right sided of the chart and then chart both tables to 1 chart.

Is this possible ?

Thanks for help,
Sirritys


  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default 2 scales in 1 chart

Well, that wasn't so hard =)

Thanks a lot =)

  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1,071
Default 2 scales in 1 chart

In article .com,
says...
Well, that wasn't so hard =)

Thanks a lot =)


You are welcome. :)
--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
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
Change scales from reference cells value for a chart in a separate sheet ers Charts and Charting in Excel 4 April 2nd 06 07:00 PM
Activating a Chart object Hari Prasadh Charts and Charting in Excel 6 August 2nd 05 07:22 PM
Urgent Chart Assistance Brent E Charts and Charting in Excel 1 May 10th 05 09:09 AM
Urgent Chart Questions Brent E Excel Discussion (Misc queries) 0 May 9th 05 11:01 PM
Urgent Chart Assistance Requested Brent E Excel Discussion (Misc queries) 0 May 9th 05 11:01 PM


All times are GMT +1. The time now is 12:39 PM.

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

About Us

"It's about Microsoft Excel"