Solved

legend problem in excel graph

Posted on 2013-11-26
2
518 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 47

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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

752 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