how to plot a graph in excel with multiple series

How do you go about charting then? Share your ideas and implementations using comments. But I am sure you get such data once in a while. I seldom deal with data that has this kind of outliers. Go ahead and download it here:Įxcel Charting options when you large and small values What would you do? I have put all these 4 chart examples in a workbook so you can see the underlying technique. Let the bars reach sky: You can of course, set axis max to an arbitrary value, just so that all the small values are clearly displayed and let the higher values literally cut thru plot area. Read broken y-axis to know how to do this.Ĥ. I have used 2 charts and aligned them neatly.

Split the axis in to two: This is the most trickiest technique. Use log scale for vertical axis (axis option > check logarithmic scale)ģ. Now, how do you go about making a chart?Ģ. That is, you have data like the numbers shown to right, with a surprising bump during Christmas time. How do we effectively plot all of them in a chart? We have a lot of small numbers and a few very large numbers. Here is an interesting charting problem we come across once in a while.

How to plot a graph in excel with multiple series