ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Second X axis at top of chart? (https://www.excelbanter.com/charts-charting-excel/247-second-x-axis-top-chart.html)

Phil Hageman

Second X axis at top of chart?
 
Is there a way to add a second X axis at the top of a chart? I want to plot
a normal distribution curve with the base on the Y axis (versus the usual X
axis) and use the second X axis at the top of the chart as its value (Y)
axis. The X axis at the bottom of the chart is already occupied with a
column series.

Bernard Liengme

Hi Phil,
Again you need two data series. If you have such a chart (maybe using my
info last time), right click chart; open the Chart Options menu; go to Axis
tab and in the bottom area locate Secondary Axis; check the Value X box

best wishes
Bernard

"Phil Hageman" wrote in message
...
Is there a way to add a second X axis at the top of a chart? I want to
plot
a normal distribution curve with the base on the Y axis (versus the usual
X
axis) and use the second X axis at the top of the chart as it's value (Y)
axis. The X axis at the bottom of the chart is already occupied with a
column series.





All times are GMT +1. The time now is 09:03 PM.

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