| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Charting in Excel
I have a colum chart in Excel and I can't seem to set the width of the
individual columns? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Charting in Excel
Format the data series setting the gap width.
-- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "Jeff" wrote: I have a colum chart in Excel and I can't seem to set the width of the individual columns? |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Charting in Excel
You can't set the widths of the individual columns. All have to have the
same width. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Wigi" wrote in message ... Format the data series setting the gap width. -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "Jeff" wrote: I have a colum chart in Excel and I can't seem to set the width of the individual columns? |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Charting in Excel
I am not setting the width of individual columns, every column is very
narrow, and I tried adjusting the gaps, but that did not help, it moved the columns closer together but did not make the columns wider. "Jon Peltier" wrote: You can't set the widths of the individual columns. All have to have the same width. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Wigi" wrote in message ... Format the data series setting the gap width. -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "Jeff" wrote: I have a colum chart in Excel and I can't seem to set the width of the individual columns? |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Charting in Excel
How far apart are the columns? Is it weekly data on a date scale axis?
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Jeff" wrote in message ... I am not setting the width of individual columns, every column is very narrow, and I tried adjusting the gaps, but that did not help, it moved the columns closer together but did not make the columns wider. "Jon Peltier" wrote: You can't set the widths of the individual columns. All have to have the same width. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Wigi" wrote in message ... Format the data series setting the gap width. -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "Jeff" wrote: I have a colum chart in Excel and I can't seem to set the width of the individual columns? |
|
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Charting in Excel
Jon,
I changed the type of chart, from a 3-D to a 2-D, and now when I set the gap it modified the width of the colums, so I have this problem fixed for now. You might be able to answer another question. I am trying to graph two cash flow streams over a 20 year period. I also want to compare this against the cumulative cost, but I would like the annual amounts plotted in columns, and the cumulaitve plotted with a line graph against a different axis. Do you have suggestions? "Jon Peltier" wrote: How far apart are the columns? Is it weekly data on a date scale axis? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Jeff" wrote in message ... I am not setting the width of individual columns, every column is very narrow, and I tried adjusting the gaps, but that did not help, it moved the columns closer together but did not make the columns wider. "Jon Peltier" wrote: You can't set the widths of the individual columns. All have to have the same width. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Wigi" wrote in message ... Format the data series setting the gap width. -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "Jeff" wrote: I have a colum chart in Excel and I can't seem to set the width of the individual columns? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Charting in Excel | Excel Discussion (Misc queries) | |||
| Excel Charting | Charts and Charting in Excel | |||
| Excel Add-Ons For Charting | Charts and Charting in Excel | |||
| help with charting in excel | Charts and Charting in Excel | |||
| Custom charting - Stacked charting with a line | Charts and Charting in Excel | |||
Hybrid Mode
