Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Column and Bar Charts
One simple question, How do I make the columns in a column chart wider that
they are created by Excel 2003? Thanks for help. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Column and Bar Charts
Double click on a column, and on the Options tab of the Format Series
dialog, reduce the Gap Width. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "PA" wrote in message ... One simple question, How do I make the columns in a column chart wider that they are created by Excel 2003? Thanks for help. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Column and Bar Charts
Thanks, that works, on most of our files that I experimented with. However,
the file needing to have the columns widened because they are far to narrow, has a gap width of 10, and I do not know why. "Jon Peltier" wrote: Double click on a column, and on the Options tab of the Format Series dialog, reduce the Gap Width. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "PA" wrote in message ... One simple question, How do I make the columns in a column chart wider that they are created by Excel 2003? Thanks for help. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Column and Bar Charts
On Mon, 7 Jan 2008, in microsoft.public.excel.charting,
PA said: Thanks, that works, on most of our files that I experimented with. However, the file needing to have the columns widened because they are far to narrow, has a gap width of 10, and I do not know why. Is it possible you have a cluster column chart, but that most series in the cluster lack data values at each point? If *all* series in the cluster lack values except one, you can set the bar overlap to be 100%, with no ill effects. -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Column and Bar Charts
Is the X axis a date scale, but you only have one data point per week? Your
gap is comprised of six empty days' of data, plus seven times the nominal gap. Change to a category axis type (Chart menu Chart Options Axes tab). - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "PA" wrote in message ... Thanks, that works, on most of our files that I experimented with. However, the file needing to have the columns widened because they are far to narrow, has a gap width of 10, and I do not know why. "Jon Peltier" wrote: Double click on a column, and on the Options tab of the Format Series dialog, reduce the Gap Width. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "PA" wrote in message ... One simple question, How do I make the columns in a column chart wider that they are created by Excel 2003? Thanks for help. |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
Column and Bar Charts
Changing to a category axis did the trick, thanks for the tip.
"Jon Peltier" wrote: Is the X axis a date scale, but you only have one data point per week? Your gap is comprised of six empty days' of data, plus seven times the nominal gap. Change to a category axis type (Chart menu Chart Options Axes tab). - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "PA" wrote in message ... Thanks, that works, on most of our files that I experimented with. However, the file needing to have the columns widened because they are far to narrow, has a gap width of 10, and I do not know why. "Jon Peltier" wrote: Double click on a column, and on the Options tab of the Format Series dialog, reduce the Gap Width. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "PA" wrote in message ... One simple question, How do I make the columns in a column chart wider that they are created by Excel 2003? Thanks for help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Column to Charts | Charts and Charting in Excel | |||
Combine Clustered Column Bar charts and Stacked column bar charts | Charts and Charting in Excel | |||
Matching the colors Column Charts and Pie Charts | Charts and Charting in Excel | |||
Line - Column Charts | Charts and Charting in Excel | |||
Column charts with multiple data in each column | Charts and Charting in Excel |