Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I have an area chart that plots quarterly data. I want to show only years on
the x-axis, so I changed the interval to 1 year and the number format to 'Custom yyyy'. However this is shortening my dates, so 2020 becomes 202. Bizarrely, 2021 and 2031 show up in full, but other dates are only shown by their first three digits. Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Format of the CHART AREA COLOR | Charts and Charting in Excel | |||
Conditional Format of the Chart AREA COLOR | Excel Discussion (Misc queries) | |||
Resize plot area in a chart area | Excel Discussion (Misc queries) | |||
How to increase chart area without affecting plot area? | Charts and Charting in Excel | |||
Resize chart area without resizing plot area | Charts and Charting in Excel |