Chart with differing x axis


Anthony Blackburn

I want to make a chart that has data from dis-similar x axis.

For example, I want to have a line graph for an x axis with a range of 50-100.
On the same chart, I want a line graph with an x axis that has a range of
90% to 110%.

How do I do this?



Mike Middleton

Anthony Blackburn -

Create an XY (Scatter) chart type with one data series (pairs of XY values).
Add the second data series to the chart. Then select one of the data series,
and choose to use a secondary axis. Adjust axis intercepts. For details,
describe your data and specify version of Excel.

- Mike Middleton

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