Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 2
Default change chart primary horizontal axis label or name

trying to change the display of a simple chart that shows data recorded each year. i want to change the "1, 2, ...10" labels or names on the primary horizontal axis for the year, but haven't figured that out.
when i introduced the year with the data, the year became plotted as data, which distorted the meaningful data.
any advice would be helpful.
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6
Default change chart primary horizontal axis label or name

Have you tried xy scatter chart. This should give you dates along the x axis. You can then change the type of graph if it isn't what you want.
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
change chart horizontal axis label or name peter wynkoop Charts and Charting in Excel 1 April 21st 13 09:57 AM
Finding second data point on primary axis of two axis chart Al Charbonneau[_2_] Charts and Charting in Excel 1 December 10th 09 12:49 AM
How to put a NAME in the Horizontal category axis label. Feejo Excel Discussion (Misc queries) 1 January 11th 08 01:42 PM
How to place a secondary y axis bar in a bar chart next to two primary y axis bars? Dmitry Excel Discussion (Misc queries) 3 May 4th 06 01:58 AM
How to place a secondary y axis bar in a bar chart next to two primary y axis bars? Dmitry Charts and Charting in Excel 2 May 4th 06 01:58 AM


All times are GMT +1. The time now is 04:32 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"