Solved

legend problem in excel graph

Posted on 2013-11-26
2
500 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
2 Comments
 
LVL 46

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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

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.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
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…

813 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now