Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
rberke
 
Posts: n/a
Default Multiple x-axes on n XY plot

My boss wants me to add a second axis to the top of an XY plot so that one of
them shows SI and the other shows I-P units for the same set of data. Does
anyone know a good way to do this?
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default Multiple x-axes on n XY plot

Hi,

Here is some information on displaying the secondary x axis.
http://www.andypope.info/tips/tip008.htm

Use of the secondary axes requires a minimum of 2 data series, one on
each set of axes. You can use the same set of data for each set of axes
and then format one series to have no markers or line style.

Cheers
Andy

rberke wrote:
My boss wants me to add a second axis to the top of an XY plot so that one of
them shows SI and the other shows I-P units for the same set of data. Does
anyone know a good way to do this?


--

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
multiple scatter graphes how to plot 3 sets of data for x y on th. frances Charts and Charting in Excel 3 May 2nd 23 11:42 AM
How do I plot an XY (scatter) graph with two Y axes? PeterAtLufbra Charts and Charting in Excel 2 April 4th 23 10:44 AM
dot plot - single x axis location with multiple y axis dots EJF Charts and Charting in Excel 2 March 23rd 06 02:15 AM
Multiple Y axes rdkaufman Charts and Charting in Excel 0 March 14th 06 01:13 AM
Need multiple revolutions on radar plot in Excel seeker Excel Discussion (Misc queries) 1 December 24th 05 02:41 AM


All times are GMT +1. The time now is 12:45 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"