Independent Lines in One Line Chart
Hello everyone, this is my first question on this forum, so first of all Hello (:
I have seen this Line Chart, I can't examine it because I just have a picture of it :/
How can I make a Line Chart just like this one? I mean I can make a chart each of them but in a different charts, so I have no idea how to put low numbers like 1.5 and high numbers like 220 in a one Line Chart.
It looks to me like the author of that chart used something like the beginnings of Peltier's panel chart procedure (https://peltiertech.com/Excel/Charts...venScales.html ). He went through all the data scaling formulas in the spreadsheet, then made the chart with three data series (down to the point in Peltier's tutorial where he has the picture of the chart with Y axis values from 0 to 0.9999999 but before adding the dummy Y axis data). At that point, rather than bother with the dummy axes, he just labeled the data points with the real Y value (not the Y value the chart is seeing) using the data label -> values from cells option and formatted the Y axis to be invisible.
Is that something you can replicate from Peltier's tutorial (note that most of the work is in the spreadsheet, not the chart)?
Originally Posted by shg
I have just read the post you've send, in somewhere there, they say "I could do 3 seperate chart and align them" and it hit me. I've checked the image again and saw 2 chart outlines, and Chart Legends just don't match up, they are not align with anything. So man who did this made 3 different chart and just align them and it would be the simplest solution for me. I'm so dumb that I couldn't think of this earlier. Just thank you so much (:
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks