Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 error "some chart types cannot be combined with other chart types. Select a different chart types" | Charts and Charting in Excel | |||
chart from pivot data does not update x-axis bar chart values - bug | Excel Discussion (Misc queries) | |||
Double-stacked Bar Chart WITH a Secondary Y Axis Line chart? | Charts and Charting in Excel | |||
How do you link chart source data when you copy the chart? | Charts and Charting in Excel | |||
Huge differences in chart values screws my bar chart scale up. | Charts and Charting in Excel |