Solved

legend problem in excel graph

Posted on 2013-11-26
2
527 Views
Last Modified: 2013-11-26
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
Comment
Question by:psemik
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 48

Accepted Solution

by:
Martin Liss earned 500 total points
ID: 39678906
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
 

Author Closing Comment

by:psemik
ID: 39679234
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

Ready to get started with anonymous questions?

It's easy! Check out this step-by-step guide for asking an anonymous question on Experts Exchange.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question