Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
kateswan
 
Posts: n/a
Default How can years be displayed in an Excel chart?

I'm trying to display years in 1 year increments at the bottom of a chart,
but it will not show up. How can I make that happen?
  #2   Report Post  
bigwheel
 
Posts: n/a
Default

Assuming that the data on your chart is arranged by year, you can set the
X-axis labels to show that information. Open the source data dialog, select
the series tab then set the range containing your years in the Category (X)
axis labels box

"kateswan" wrote:

I'm trying to display years in 1 year increments at the bottom of a chart,
but it will not show up. How can I make that happen?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can years be displayed in an Excel chart? kateswan Excel Discussion (Misc queries) 0 July 22nd 05 09:56 PM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
Excel should have an open/close high/low chart for stock market u. Harold Hommes Charts and Charting in Excel 2 March 24th 05 04:08 PM
How can I print an excel chart so a picture is not distorted? MJADAMS Charts and Charting in Excel 0 February 9th 05 03:03 PM
How to change the color of all series in an excel chart in one go. Mz2 Charts and Charting in Excel 1 January 20th 05 01:07 AM


All times are GMT +1. The time now is 12:20 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"