Looking Good Line Graph With Too Many Lines

In this case smooth the line to make the overall trend more apparent and take the focus away from the point to point variation.

Line graph with too many lines. How to create a line graph. Apply number format to the axis yyyy in this case. Worst performing sales people by brand territory time.

Elias de Korte on 4 Feb 2019. We suggest you dont compare more than four variables when creating a dual axis chart. Youll want to play with it a bit but I found that widths of Series1 9 Series2 55 Series3 35 and Series4 2 produce a fairly readable chart.

You are building a spaghetti chart and readers will struggle to get info from it. I would like to show only a max of 5 lines by creating a condition for eg. When there are multiple blocks of data Line charts still work mostly the same as XY Scatter charts.

Lets look at this simple data. Check curved line if needed. Start by creating a Line chart from the first block of data.

Try to understand what really matters highlight it and annotate it to make sure people get your point. For each line enter data values with space delimiter label and color. I have an interesting challenge that has probably happened to most of the developers.

Its called a line graph. A good rule of thumb is to limit yourself to five or fewer lines lest. Add a title and apply text formatting.