How to create a line chart with two X-axes in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
select one of your data series and change axis to secondary. <chart><<chart
options><Axis> Select secondary x axis.
 
Hello, thank you for replying.

Which chart type would allow for 2 X-axes. The only chart type that I know
that allows for 2 axes is "Line Chart with 2 Y-axes".

For the above-mentioned chart, the option to designate a primary and
secondary x-axis is displayed at the bottom of the "Source Data" window.
However, once the chart is created, only one x-axis scale is shown. I was
thinking that one x-axis scale would be along the bottom of the chart, and
the secondary x-axis scale would run along the top of the chart. But only
one x-axis appeared?

Please Help. Thanks
 

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

2 Horizinotal axes in Excel 2007 8
Creating a line chart with two X-axes!! 1
setting scale on chart automatically 1
How do I create a stacked-bar/Line combination chart? 1
Chart 2 axis 2
Switching X and Y axes 1
VBA to set the font size for the axes of a bar chart 1
how to create a line-chart with 2 sets of data who has different x 1

Back
Top