Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 89
Default data table labels for x axis

When putting excel data table on a chart, the label on the tables is
appearing as number versus date format. I have two charts one shows the date
format as it should be and the other chart pulling from the same data source
is showing numbers. Any help would be appreciated.
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 235
Default data table labels for x axis

It appears that the data table initially takes the format of the data source.
As a result, you might check that the chart data source is in a date format.
The formatting for the data table can be manually changed after that.

--
John Mansfield
http://www.cellmatrix.net


"Christy" wrote:

When putting excel data table on a chart, the label on the tables is
appearing as number versus date format. I have two charts one shows the date
format as it should be and the other chart pulling from the same data source
is showing numbers. Any help would be appreciated.

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
Nested Data Axis Labels ratpha Charts and Charting in Excel 0 May 18th 09 01:05 PM
excel 07 not displaying all Pivot Table x-axis labels curve_ball Charts and Charting in Excel 0 July 21st 08 08:45 PM
Data labels along below x axis when y axis has negative values Andrew Charts and Charting in Excel 1 July 3rd 08 08:36 PM
Y2 Axis Labels on Y1 Data Point Brad K. Charts and Charting in Excel 1 June 7th 07 08:38 PM
data series and axis labels cdwinlib Charts and Charting in Excel 2 May 11th 07 12:17 PM


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