Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Very Simple Question
I've just created my first bar chart and I'm stuck in some very small way. I
have 26 weeks on my X axis, comparing 2005 v 2006 - visually this is charted from col E to Col X. But how can I get each Column itself to fill the width of each particular week? At the moment its the width of a Pin and its difficult to make out the 2005 & 2004 figures. I've used the same Bar Chart showing 7 months and thats fine, so not sure. I've tweaked the Scale (Major and Minor units to 7 days) and Gap Width (to Zero), but it doesn't improving anything. Am I doing somthing exceedingly silly? Thanks |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Very Simple Question
Not clear why:"I've tweaked the Scale (Major and Minor units to 7 days)"
Major and minor units the same? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "John" wrote in message ... I've just created my first bar chart and I'm stuck in some very small way. I have 26 weeks on my X axis, comparing 2005 v 2006 - visually this is charted from col E to Col X. But how can I get each Column itself to fill the width of each particular week? At the moment its the width of a Pin and its difficult to make out the 2005 & 2004 figures. I've used the same Bar Chart showing 7 months and thats fine, so not sure. I've tweaked the Scale (Major and Minor units to 7 days) and Gap Width (to Zero), but it doesn't improving anything. Am I doing somthing exceedingly silly? Thanks |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Very Simple Question
Yes Bernard, major and Minor are the same i.e. 7. Visually it looks like
each column only cover Monday, if that makes sense "Bernard Liengme" wrote in message ... Not clear why:"I've tweaked the Scale (Major and Minor units to 7 days)" Major and minor units the same? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "John" wrote in message ... I've just created my first bar chart and I'm stuck in some very small way. I have 26 weeks on my X axis, comparing 2005 v 2006 - visually this is charted from col E to Col X. But how can I get each Column itself to fill the width of each particular week? At the moment its the width of a Pin and its difficult to make out the 2005 & 2004 figures. I've used the same Bar Chart showing 7 months and thats fine, so not sure. I've tweaked the Scale (Major and Minor units to 7 days) and Gap Width (to Zero), but it doesn't improving anything. Am I doing somthing exceedingly silly? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
a very simple question | Excel Discussion (Misc queries) | |||
Follow-Up (Clarification) to MIN question | Excel Discussion (Misc queries) | |||
simple Wildcard Question | Excel Discussion (Misc queries) | |||
Simple Question | Excel Worksheet Functions | |||
Benefits many people - Question | Excel Discussion (Misc queries) |