ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   formatting DATA bars (https://www.excelbanter.com/charts-charting-excel/240720-formatting-data-bars.html)

Gklass

formatting DATA bars
 
I've just discovered that 007 has an interesting "style" featu data
bars. -- it took me a while.

Data bars are horizontal single-cell bars based on the cell's numeric
value.

Unfortunately, each bar is shaded in two-colors (one of them white)
and tends to fade out on the right hand side of the bar.

If anything, it would be better to fade out on the left hand side.

Is there anyway to format the shading (like you can do on bar chart
bars)?

I know how to do this using the Webdings font and the letter "g" --and
that approach has several advantages, including vertical alignment,
but I wonder if I might be able to play with these bars.

Misange

formatting DATA bars
 
This is not possible in 2007 but has been greatly enhanced in the next
version, 2010, which should be released in ...2010.
Misange migrateuse
http://www.excelabo.net


Gklass a écrit :
I've just discovered that 007 has an interesting "style" featu data
bars. -- it took me a while.

Data bars are horizontal single-cell bars based on the cell's numeric
value.

Unfortunately, each bar is shaded in two-colors (one of them white)
and tends to fade out on the right hand side of the bar.

If anything, it would be better to fade out on the left hand side.

Is there anyway to format the shading (like you can do on bar chart
bars)?

I know how to do this using the Webdings font and the letter "g" --and
that approach has several advantages, including vertical alignment,
but I wonder if I might be able to play with these bars.



All times are GMT +1. The time now is 01:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com