Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Fooling Excel on Time Series Charts
I have lots of data based on weekly results, and would like to chart this
data by week. When I create bar charts from this data **without** the dates on the x-axis, the charts are nicely spaced and look like a normal bar chart. However, when I add the dates as the x-axis labels, Excel converts it to a time series chart, and the scale changes. Instead of maybe 8-10 nicely sized bars with reasonable gaps, I now have very narrow bars spread by large gaps. I know I can change the options to increase the bar size and reduce the gap, but at best it doesn't come close to the non-time series bar chart. I'm sure there's some way to override this feature in Excel, but I haven't been able to figure it out. The only option I've found is to convert the dates to text, then use the text for the x-axis labels. Is there an option I'm missing on this? Thanks, Todd |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Fooling Excel on Time Series Charts
Right-click the chart axis labels, select 'Format Axis' from the drop-down
menu, in Axis options set the Axis Type to Text (instead of the default 'automatically select on data') Ed Ferrero www.edferrero.com I have lots of data based on weekly results, and would like to chart this data by week. When I create bar charts from this data **without** the dates on the x-axis, the charts are nicely spaced and look like a normal bar chart. However, when I add the dates as the x-axis labels, Excel converts it to a time series chart, and the scale changes. Instead of maybe 8-10 nicely sized bars with reasonable gaps, I now have very narrow bars spread by large gaps. I know I can change the options to increase the bar size and reduce the gap, but at best it doesn't come close to the non-time series bar chart. I'm sure there's some way to override this feature in Excel, but I haven't been able to figure it out. The only option I've found is to convert the dates to text, then use the text for the x-axis labels. Is there an option I'm missing on this? Thanks, Todd |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Fooling Excel on Time Series Charts
Ok, great.
Thanks, Todd "Ed Ferrero" wrote: Right-click the chart axis labels, select 'Format Axis' from the drop-down menu, in Axis options set the Axis Type to Text (instead of the default 'automatically select on data') Ed Ferrero www.edferrero.com I have lots of data based on weekly results, and would like to chart this data by week. When I create bar charts from this data **without** the dates on the x-axis, the charts are nicely spaced and look like a normal bar chart. However, when I add the dates as the x-axis labels, Excel converts it to a time series chart, and the scale changes. Instead of maybe 8-10 nicely sized bars with reasonable gaps, I now have very narrow bars spread by large gaps. I know I can change the options to increase the bar size and reduce the gap, but at best it doesn't come close to the non-time series bar chart. I'm sure there's some way to override this feature in Excel, but I haven't been able to figure it out. The only option I've found is to convert the dates to text, then use the text for the x-axis labels. Is there an option I'm missing on this? Thanks, Todd |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Charts switch from 'Series in Rows' to 'Series in Columns' | Charts and Charting in Excel | |||
How do I plot multiple x-axis series in excel charts | Charts and Charting in Excel | |||
Alternatives for Excel for charting dated time-series? | Charts and Charting in Excel | |||
How do I graph a quarterly time-series in Excel? | Charts and Charting in Excel | |||
Excel Charts: Can I show standard deviation on selected series? | Charts and Charting in Excel |