| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to alter width of columns in Column Charts?
Hi,
I am having trouble with creating a readable column chart as the columns within it are so thin that it is impossible to see what colour they are. Is it possible to edit column width within a chart? If so please do tell as I dont have much more hair to pull out! |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How to alter width of columns in Column Charts?
You can change all the columns at once. Double click a column series, and on
the Options tab, change the gap width. Zero means no gap, the bars are touching. If you have dates on the X axis, using Days as your units, and you have one column per week, you will have six days per week without a column. You can't make the columns wider than one category axis unit. You could change to a category type axis: Chart menu Chart Options Axes tab, select Category instead of Auto or Time Scale. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "TimJim" wrote in message ... Hi, I am having trouble with creating a readable column chart as the columns within it are so thin that it is impossible to see what colour they are. Is it possible to edit column width within a chart? If so please do tell as I dont have much more hair to pull out! |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How to alter width of columns in Column Charts?
Thanks, that was exactly what I needed :)
"Jon Peltier" wrote: You can change all the columns at once. Double click a column series, and on the Options tab, change the gap width. Zero means no gap, the bars are touching. If you have dates on the X axis, using Days as your units, and you have one column per week, you will have six days per week without a column. You can't make the columns wider than one category axis unit. You could change to a category type axis: Chart menu Chart Options Axes tab, select Category instead of Auto or Time Scale. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "TimJim" wrote in message ... Hi, I am having trouble with creating a readable column chart as the columns within it are so thin that it is impossible to see what colour they are. Is it possible to edit column width within a chart? If so please do tell as I dont have much more hair to pull out! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTIF in between rows | Excel Worksheet Functions | |||
| How do I combine spreadsheets and documents in one file? | Excel Discussion (Misc queries) | |||
| seperate first 2 lines of column in seperate columns in same row | Excel Discussion (Misc queries) | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| How can I sort an entire spreadsheet from a list | Excel Worksheet Functions | |||
Hybrid Mode
