Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

legend problem in excel graph

Posted on 2013-11-26
2
Medium Priority
?
539 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 49

Accepted Solution

by:
Martin Liss earned 1500 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
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.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

715 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