Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Hi,
The columns are skinny as they are representing 1 day in your date period. You can increase the thickness by double clicking and setting the Gap width to zero on the Series Option tab. The increase will not be huge though. If your dates are of equal intervals, i.e. 12 data points for each year, you could set the axis to be Category rather than Time series. Right click the chart and pick Chart Options. On the Axes tab you can specify the axis type. Cheers Andy tdebo wrote: I have created a 2 series basic column chart. It has dates as the primary axis with years as the secondary. It is comparing data from each month year over year, across 3 years. And it's comparing two types of data, calls offered, and calls answered. Needless to say, it's a rather busy chart. The only problem I have with it right now, is that given the type of chart and all the data, the columns are SUPER skinny. Is there a way to manually make the columns fatter? Please help! Thanks!! -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Want graph with 2 axis, but bars overlap when second axis added | Charts and Charting in Excel | |||
Ho do I make my data series touch the axis? | Charts and Charting in Excel | |||
How to place a secondary y axis bar in a bar chart next to two primary y axis bars? | Excel Discussion (Misc queries) | |||
How to place a secondary y axis bar in a bar chart next to two primary y axis bars? | Charts and Charting in Excel | |||
How to make Three Bars and one line with a second axis in EXCEL | Charts and Charting in Excel |