Solved

Excel - Line Graph

Posted on 2011-03-20
4
194 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

808 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