Forum Discussion
Line chart legends issue for single series
Hi Team,
I am facing an issue in a line chart with single legend series and multiple category axis labels. The legend shows the category axis labels (which are multiple) instead of the series name (which is just a single).
This is the chart screenshot
Here, basically I'm expecting legend to show just one legend series name which is Test.
Instead it shows 12 legends which is category axis labels.
Pls find the data below which I'm using to generate the excel.
| Periods | Category | xyz |
| Week1 | Test | 119830648.96 |
| Week2 | Test | 123725962.18 |
| Week3 | Test | 121654365.27 |
| Week4 | Test | 115871275.72 |
| Week5 | Test | 118692146.55 |
| Week6 | Test | 123821205.11 |
| Week7 | Test | 111731178.64 |
| Week8 | Test | 122901637.91 |
| Week9 | Test | 116757884.33 |
| Week10 | Test | 127667286.52 |
| Week11 | Test | 125845377.80 |
| Week12 | Test | 128271005.73 |
Please help me to get the legend with single series instead of the 12 labels. Ima tyring to attach excel, but unable to. Let me know how can I attach the excel sheet.
Thanks,
Thilak Babu
9 Replies
Click anywhere in the chart.
On the Chart Design tab of the ribbon, click Select Data.
The dialog should look like this:
If you click Edit under Legend Entries (Series), it should look similar to this:
And if you click Edit under Horizontal (Category) Axis Labels:
You should then get:
Hi HansVogelaar
I did the same whatever you have mentioned.
Still I'm seeing the legends as Week1 Test to Week12 Test instead of TestLegend entry series :
Category axis labels :
So, could you please help me further! Thanks in advance!
Thanks,
Thilak Babu
Try creating the chart again from scratch:
- Select the source range as shown in your first post.
- Insert a line chart.
If I do that, I get the correct chart. The only things that need to be changed are the minimum, maximum and major unit of the y-axis.
