Solved

Excel - Line Graph

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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

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.
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
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…

810 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