Hi all,
See the attached sample workbook. The two charts are before and after adding the most recent data - which has massive outliers on half the plotted series, due to lockdown2. I don't want to lose the visual on the rest of the data in the way that including the outliers makes happen.
My immediate thought was I guess I'll have to break the vertical axis, not having done it before I needed to find out how and found this.
https://peltiertech.com/broken-y-axis-in-excel-chart/
I generally agree it gives a better way. If you're using a bar chart.
However, my chart is a line graph, and the dummy series he creates plot separately rather than hiding behind the original bars, because they're not bars. As such it's simply not going to work.
Anyone got a suggestion?
For context, and to forestall suggestions to just remove the outlier, this won't just be a one-off blip, I'm working on this week's data and series E and F continue roughly where they are, increasing slightly, and series B and C DECREASE, I expect that to continue until lockdown is over, when we'll see D and E spring back down and B and C start to recover again.
Thanks in advance
Bookmarks