Forum Discussion

Copper Contributor

Jul 28, 2022

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 nam...

Charting

ThilakBabu

Copper Contributor

Jul 28, 2022

Hi HansVogelaar

I did the same whatever you have mentioned.

Still I'm seeing the legends as Week1 Test to Week12 Test instead of Test

Legend entry series :

Category axis labels :

So, could you please help me further! Thanks in advance!

Thanks,

Thilak Babu

HansVogelaar

MVP

Jul 28, 2022

ThilakBabu

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.

ThilakBabu
Copper Contributor
Jul 28, 2022
Hi HansVogelaar ,

We created the excel programmatically.
The use case is to show only one legend. So trying to understand how I can change the same excel to achieve it . Please let me know if I can share the excel in case you need to take a look.

Thanks,
Thilak Babu
- HansVogelaar
  MVP
  Jul 28, 2022
  ThilakBabu
  
  Yes, please attach or share the workbook.
  - ThilakBabu
    Copper Contributor
    Jul 28, 2022
    HansVogelaar
    
    I could not find an option to attach the excel. I am seeing an option only to attach an image. Could you please guide me to attach the excel ?
    
    Thanks,
    Thilak Babu