CODEWITHSUNDEEP
excelgraphline
David777
David777

Reputation: 211

How to create a line graph on Excel which have very different values

I have a question about plotting a line graph on Excel.

I have 4 variables (say a, b, c, and d) which will be plotted on the vertical axis against one other variable (say x) which will be plotted on the horizontal axis.

Now variables a and b have large values in the millions where as variables c and d have very small values less than 1.

Is it possible to plot this on one line graph instead of having to create two graphs? (i.e a graph for the large values and a graph for the small values)

As the scale is so big for the large data values, the two small data values appear on top of each other and is unclear.

Thanks

Upvotes: 2

Views: 1432

Answers (1)

Naresh
Naresh

Reputation: 3034

Yes... You can create second vertical axis either for a and b or for c and d.. Just keep in mind you can define where the x(horizontal) axis crosses at the left(first) vertical axis. Add all the series (a, b, c, and d) and then right click one by one those you want to take to the second vertical axis and select "Format Data Series" and then select secondary axis in the series options

enter image description here

Upvotes: 2

Related Questions