To make a graph with a single Y-axes but two different ranges

**capercas** · 01-20-2016, 02:44 PM

Hi all,

I would like to know if it is possible in excel to make a (line) graph where I have just one Y-axis but with different interval (ranges).
In my case my values go from 0 to 1,8000,000 (hectares) but most of my values are concentrated between 0 and 800,000 and just one data set in 1,780,000.
I would like to "amplify" for a better visual interpretation the range between 0 and 800,000 where I have most of the values (lines in this case).

Thank you very much in advance.
Kind regards,
Carolina

**MrShorty** · 01-20-2016, 03:12 PM

Clarification, are you wanting a "line" chart, or an XY scatter chart? Since I would not expect much of a problem with this using a "line" chart, I am assuming you are wanting an XY Scatter chart.

My first thought is to plot the data in a "panel chart" (tutorial here: http://peltiertech.com/Excel/ChartsH...venScales.html ). The tutorial is for different Y ranges with the panels stacked vertically. Once you understand how he puts this chart together, it should be fairly straightforward to adapt to different X ranges with panels arranged side by side. You could have one panel showing the data between 0 and 1E6 hectares to show the variation between those values, then have the 2nd panel that goes from 0 to 2E6 hectares to show the final data point in relation to the others.

**capercas** · 01-21-2016, 05:15 AM

Hi MrShorty,

This is exactly what I was looking for...
I am going to follow the tutorial to create mu chart...

Thank you so much, I really appreciate you useful help!

Kind regards,
Carolina

To make a graph with a single Y-axes but two different ranges

LinkBack

Thread Tools

Rate This Thread

Display

To make a graph with a single Y-axes but two different ranges

Re: To make a graph with a single Y-axes but two different ranges

Re: To make a graph with a single Y-axes but two different ranges

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Plotting a standard bar graph on the same axes as a stacked bar graph

How to make date ranges for graph example, choose start and end date

Make date ranges for graph (choose start and finish date)

How do I make this single graph?

colum graph on 2 axes

Macro to make a graph: help selecting the data ranges.

Excel bar graph with two axes

Bookmarks

Bookmarks

Posting Permissions