1

I'm trying to set up an Excel chart. I've tried to enter 6 data series. I have followed the steps correctly, but on the graph it only shows 5 lines. On the right-hand side listing of series, it shows the 6 I want.

Why are only 5 showing on the chart? Is there a maximum number of series?

0

1 Answer 1

3

There most likely is a limit to the amount of data series in an Excel chart, but I doubt it is as low as 5. Your lines are possibly overlapping.


As you can see here, there is no issue with 6 separate data series in a line chart:

6 data series in a line graph

However, if values overlap, only 5 lines are visible: 6 data series with overlapping data

0

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .