Second X axis at top of chart?

P

Phil Hageman

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.
 
B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scatter chart with categories on x-Axis 2
Make Y-axis values correspond to x- axis value 1
Excel 2010 - Line Chart with Mulitiple Data Sets 1
Use text descriptors as Y axis units 1
Adding a line to a population bar chart 0
Chart distorts secondary axis when the x-axis is logarithmic 5
Positioning x axis at bottom of chart with negative values 5
One extra x axis item that wont go away - can anyone help? 3

Top