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. |
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. |
All times are GMT +1. The time now is 06:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com