ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   thickening a bar in a chart (https://www.excelbanter.com/charts-charting-excel/148985-thickening-bar-chart.html)

Jonny

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?

ShaneDevenshire

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