Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Increasing width of columns in column chart
I have a column chart created and the columns are like pin stripes - I have
tried reducing the gap and so forth but can't find a way to make the columns wide enough to be useful. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Increasing width of columns in column chart
"Shelly" wrote: I have a column chart created and the columns are like pin stripes - I have tried reducing the gap and so forth but can't find a way to make the columns wide enough to be useful. Shelly, I ran into this very same thing on Monday. I found that the width of the columns was being determined by the legend of the Y-axis. as an example: I was graphing about 4-months of statistical data and grabbed the date column for 4-months for the Y-axis. Since all the dates wouldn't show I found the graph "auto-scrunching" my column graphs just to fit as many date labels in as possible across the bottom. When I modified what and how the dates would be displayed I found the columns returned to normal or expected size. Note: I believe this is a new feature in Excel 2007 as I don't recall older versions changing columns to pin-lines, they were reduced but not as bad. Hope this helps -Steve |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Increasing width of columns in column chart
Is the category axis showing dates? And is the data weekly, not daily? This
means you have six blanks dates for each date with a value, and therefore the gaps are very wide. Change to a category scale axis. Excel 2003: Chart menu Chart Options Axes tab, choose Category option for the Category axis. Excel 2007: Format Axis, about midway down the first tab, choose Date Axis. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Shelly" wrote in message ... I have a column chart created and the columns are like pin stripes - I have tried reducing the gap and so forth but can't find a way to make the columns wide enough to be useful. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart column width | Charts and Charting in Excel | |||
How do I change the width of data columns in a column chart? | Charts and Charting in Excel | |||
How can I set width of the columns in the column graph? | Charts and Charting in Excel | |||
Gantt Chart with variable width columns - is this possible? | Charts and Charting in Excel | |||
Change the width of a single column in a column chart | Charts and Charting in Excel |