ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Second catagory axis in XY chart (https://www.excelbanter.com/charts-charting-excel/217863-second-catagory-axis-xy-chart.html)

Jim

Second catagory axis in XY chart
 
A Standard Distribution chart needs to have 2 catagory axes which show (i)
the X values and (ii) the normalised X values. Or rather it would be nice to
do this.
Any ideas out there?
Jim

David Biddulph[_2_]

Second catagory axis in XY chart
 
From among the series on the chart, choose the series that you wish to use
the secondary axis, then Format Data Series/ Axis tab & choose secondary.
This will initially put a secondary Y axis, but if you now use Chart
Options/ Axis tab it allows you to add a secondary X axis.
--
David Biddulph

"Jim" wrote in message
...
A Standard Distribution chart needs to have 2 catagory axes which show (i)
the X values and (ii) the normalised X values. Or rather it would be nice
to
do this.
Any ideas out there?
Jim




Jim

Second catagory axis in XY chart
 
Thanks for that David, who'd have thought?!
Is there any way of moving the 2nd X axis so it's along the bottom, under
the primary X axis?

"David Biddulph" wrote:

From among the series on the chart, choose the series that you wish to use
the secondary axis, then Format Data Series/ Axis tab & choose secondary.
This will initially put a secondary Y axis, but if you now use Chart
Options/ Axis tab it allows you to add a secondary X axis.
--
David Biddulph

"Jim" wrote in message
...
A Standard Distribution chart needs to have 2 catagory axes which show (i)
the X values and (ii) the normalised X values. Or rather it would be nice
to
do this.
Any ideas out there?
Jim






All times are GMT +1. The time now is 09:52 AM.

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