Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Bar graph -bars not evenly spaced
Hi,
I have a simple bar graph which has 4 series but about 99 data points (i.e. there are 99 bars shown.) My problem is that the bars are not evenly spaced within the chart, so I don't get a nice graph. One series, consistently, is about 2 pixels right of it's 'area'. I cannot find an option to centre the bar above its description. Changing the bar's borders does not work, changing the size of the graph does not work. Changing the Overlap or Gap Width options does not work either! Any ideas? This problem has been found on both Excel 2002(XP) and Excel 2007. Do I have too many bars for excel to cope with? TIA Sarah |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Bar graph -bars not evenly spaced
bar or column
I have 2003 XP I do not see a problem with mine which column (I think) is wrong "Sarah Marriott" wrote: Hi, I have a simple bar graph which has 4 series but about 99 data points (i.e. there are 99 bars shown.) My problem is that the bars are not evenly spaced within the chart, so I don't get a nice graph. One series, consistently, is about 2 pixels right of it's 'area'. I cannot find an option to centre the bar above its description. Changing the bar's borders does not work, changing the size of the graph does not work. Changing the Overlap or Gap Width options does not work either! Any ideas? This problem has been found on both Excel 2002(XP) and Excel 2007. Do I have too many bars for excel to cope with? TIA Sarah |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Bar graph -bars not evenly spaced
It's a clustered type chart, right? Bar or column? 99 bars/columns is kind
of a lot. Are some bars/columns 2 pixels wide and others 3? Do some series not have data for all categories? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Sarah Marriott" wrote in message ... Hi, I have a simple bar graph which has 4 series but about 99 data points (i.e. there are 99 bars shown.) My problem is that the bars are not evenly spaced within the chart, so I don't get a nice graph. One series, consistently, is about 2 pixels right of it's 'area'. I cannot find an option to centre the bar above its description. Changing the bar's borders does not work, changing the size of the graph does not work. Changing the Overlap or Gap Width options does not work either! Any ideas? This problem has been found on both Excel 2002(XP) and Excel 2007. Do I have too many bars for excel to cope with? TIA Sarah |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Bar graph -bars not evenly spaced
Thanks for the reply.
To clarify its a column chart, and your comment about series has just made it click. I didn't realise I had selected a clustered column chart. Doh! I have now chosen Stacked Column (even though there is only one value) and its great. Cheers for making it clearer! Sarah "Jon Peltier" wrote: It's a clustered type chart, right? Bar or column? 99 bars/columns is kind of a lot. Are some bars/columns 2 pixels wide and others 3? Do some series not have data for all categories? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Sarah Marriott" wrote in message ... Hi, I have a simple bar graph which has 4 series but about 99 data points (i.e. there are 99 bars shown.) My problem is that the bars are not evenly spaced within the chart, so I don't get a nice graph. One series, consistently, is about 2 pixels right of it's 'area'. I cannot find an option to centre the bar above its description. Changing the bar's borders does not work, changing the size of the graph does not work. Changing the Overlap or Gap Width options does not work either! Any ideas? This problem has been found on both Excel 2002(XP) and Excel 2007. Do I have too many bars for excel to cope with? TIA Sarah |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
i have to add cells evenly spaced, eg a1 + a11+a21+...+a991 | Excel Worksheet Functions | |||
Can't get evenly spaced chart x-axis labels | Excel Discussion (Misc queries) | |||
evenly spaced page breaks | Excel Discussion (Misc queries) | |||
Variable dates on X axis evenly spaced (should not be) | Charts and Charting in Excel | |||
Formula to autofill with an evenly spaced increment of rows? | Excel Discussion (Misc queries) |