Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dates appear wrong in my chart
I have a bar chart I have created from a table. I want the x axis to be the
dates shown in the table. currently 11/01/2007, 11/01/2006, etc. They appear in the chart as 01/01/2007, 01/01/2006, etc. If I change the formatting in the chart from date to number than the dates in the chart appear 11/01/2007, 11/01/2006, etc. How do I get both the table and the chart to display the correct date? Has anyone experienced a simliar problem? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dates appear wrong in my chart
I have a bar chart I have created from a table. I want the x axis to be the
dates shown in the table. currently 11/01/2007, 11/01/2006, etc. They appear in the chart as 01/01/2007, 01/01/2006, etc. If I change the formatting in the table from date to number than the dates in the chart appear 11/01/2007, 11/01/2006, etc. How do I get both the table and the chart to display the correct date? Has anyone experienced a simliar problem? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add chart - what is wrong with the code? | Charts and Charting in Excel | |||
dates automatically formatted wrong | Excel Discussion (Misc queries) | |||
line chart displays wrong values | Charts and Charting in Excel | |||
In Excel spreadsheeet the dates change to the wrong date after we. | Excel Discussion (Misc queries) | |||
I get wrong dates when i paste from a different sheet into a new s | Excel Discussion (Misc queries) |