Solved

Excel - Line Graph

Posted on 2011-03-20
4
178 Views
Last Modified: 2012-08-13
Hi,

In the line graph, I am unable to produce the year as shown below?  Please provide support.I am using OFFICE 2010 professional version. Thanks.



Total World      3701      3866      3897      3915      3907
Year      2003      2004      2005      2006      2007

JANANI-20.03.11.xls
0
Comment
Question by:JohnSrinivassan
4 Comments
 
LVL 1

Accepted Solution

by:
Jon_Peltier earned 250 total points
ID: 35176834
Put the year onto a column on the worksheet. Put the values into the next column. Leave the cell above the years blank. Put the desired series name into the cell above the values. Create your chart.

The blank top-left cell helps Excel determine that it should use the first column for horizontal axis labels and the first row as series names.
0
 
LVL 50

Assisted Solution

by:Ingeborg Hawighorst
Ingeborg Hawighorst earned 250 total points
ID: 35177166
Hello,

in addition to Jon's tip: if you want to fix an existing chart without redrawing it, you can follow these steps:

- right-click the chart and click Select Data in the context menu
- click the Year series and click Remove
- click the Edit button for the Horizontal (Category) Axis Labels in the right hand side of the dialog box
- select cells A2 to A6 as your axis labels

Depending on how much you've already tweaked your chart, this might be less work than starting over from scratch.

cheers, teylyn
0
 
LVL 24

Expert Comment

by:broomee9
ID: 35821677
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
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…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

895 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

11 Experts available now in Live!

Get 1:1 Help Now