Solved

Excel - Line Graph

Posted on 2011-03-20
4
167 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
Comment Utility
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:teylyn
teylyn earned 250 total points
Comment Utility
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
Comment Utility
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

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Suggested Solutions

What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

763 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

6 Experts available now in Live!

Get 1:1 Help Now