![]() |
thickening a bar in a chart
Is there a way to thicken a bar?
I have plotted daily values and once every 365 days an annual value. As a result my annual value looks like a very thin bar (barely seeable). Is there any way to thicken my annual value? I don't want it to fill the chart, just be a little thicker than a single value every 365 days? |
thickening a bar in a chart
Hi,
chart options which make bars wider apply to all bar (columns). One way to beat this limit is to repeat the date onwhich the annual total appears a number of times and enter the value a corresponding number of times. To make the bars look like one bar you can set the gap width under the series options to 0 and set the border lines to none on the Patterns tab. If reducing the gap width to 0 for the other dates presents a problem then insert empty data items between each entry in the original data source. Alternatively run a second data series with only the annual data point and repeat that data point as above. -- Cheers, Shane Devenshire "jonny" wrote: Is there a way to thicken a bar? I have plotted daily values and once every 365 days an annual value. As a result my annual value looks like a very thin bar (barely seeable). Is there any way to thicken my annual value? I don't want it to fill the chart, just be a little thicker than a single value every 365 days? |
All times are GMT +1. The time now is 07:54 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com