Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 556
  • Last Modified:

legend problem in excel graph

i have a simple line graph in excel. there are 6 lines in the graph and all are displayed with no problems.
i have a cell for each entry i want in the legend. for some reason one of these is not displayed in the legend of the graph.
the series in the chart data range is correct - all cells are included.
in 'select data source-legend entries' all 6 entries for the legend are listed. however, in the graph itself only five of these 6 entries are displayed.
i have spent much time trying to figure this out.
i hope one of the experts has the solution.
thanks
pat
0
psemik
Asked:
psemik
1 Solution
 
Martin LissRetired ProgrammerCommented:
Right click on the axis and select Format Axis. Is there anything there that explains the problem? If not then can you post a picture of what you see and what you want to see?
0
 
psemikAuthor Commented:
I have tried all of  these things. I have recreated the graph from scratch in a different sheet and I no longer have this problem.
thanks for your time.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now