thickening a bar in a chart

[jonny]

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?

 

[ShaneDevenshire]

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.