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

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
  - HansVogelaar
    MVP
    Jul 28, 2022
    ThilakBabu
    
    If you cannot attach a workbook, you can upload it to for example OneDrive, Google Drive or Dropbox, then get a link to the uploaded file and post that in a reply.
    
    Or you can send me a private message; you should be able to attach a file there.