ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Multiple x-axes on n XY plot (https://www.excelbanter.com/charts-charting-excel/84107-multiple-x-axes-n-xy-plot.html)

rberke

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?

Andy Pope

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


All times are GMT +1. The time now is 05:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com