Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I have data bars WITHOUT the clour fading to the right?
It's not very much, but I'm going crazy because of this.
When you choose to display data bars for your data€” say I choose blue data bars€” the data bars appear, just that there is a gradient; they fade from blue to white to the right. This makes it hard to see where the bars end (I'm not a perfectionist really, I swear) and when your cells are coloured anyway, like mine are, it's hard to tell where the bars end! AAAARRH! Can anyone help me?! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I have data bars WITHOUT the clour fading to the right?
The data bars are designed to fade in this way. If you're a perfectionist,
these are not a great tool, since the length of the bars isn't really proportional to the cell values. Don't believe me? Enter 0, 0.1, ..., 1.0 into a range, and format the range with data bars. The cell with zero still has a bar with finite length; in fact the bar lengths in this range are described by (Value-Min+delta)/(Max-Min+2*delta), where delta is around 0.1*(Max-Min). - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "MentalDan" wrote in message ... It's not very much, but I'm going crazy because of this. When you choose to display data bars for your data- say I choose blue data bars- the data bars appear, just that there is a gradient; they fade from blue to white to the right. This makes it hard to see where the bars end (I'm not a perfectionist really, I swear) and when your cells are coloured anyway, like mine are, it's hard to tell where the bars end! AAAARRH! Can anyone help me?! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I have data bars WITHOUT the clour fading to the right?
I've just noticed; MentalDan is a TERRIBLE Display Name.
Thanks Jon or Mr. Pelter€” I don't know; you seem very reputable... sir€” and for Microsoft, a stupid mistake like that (0 appearing with an actual bar) is unacceptable. However, I use numbers way above the zero mark and so such a small error in bar length proportionate to one another is not so noticeable. Are you sure there is NO way to remove the gradient aspect of it so it DOESN'T fade to white near the end? I presume a "No" reply. Thanks Mr. Pelter, again. Do you, by any chance, WORK for Microsoft, or has your website and occupation got nothing to do with them? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I have data bars WITHOUT the clour fading to the right?
I'm not 100% certain, but this fancy new interface is supposed to make your
work easier, and it showed me no way to do so. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "MentalDan" wrote in message ... I've just noticed; MentalDan is a TERRIBLE Display Name. Thanks Jon or Mr. Pelter- I don't know; you seem very reputable... sir- and for Microsoft, a stupid mistake like that (0 appearing with an actual bar) is unacceptable. However, I use numbers way above the zero mark and so such a small error in bar length proportionate to one another is not so noticeable. Are you sure there is NO way to remove the gradient aspect of it so it DOESN'T fade to white near the end? I presume a "No" reply. Thanks Mr. Pelter, again. Do you, by any chance, WORK for Microsoft, or has your website and occupation got nothing to do with them? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I change a graph with 2 bars,2 lines to 3 bars, 1 line? | Charts and Charting in Excel | |||
How do I add error bars unique to each data point? | Charts and Charting in Excel | |||
Lost all my menu bars and tool bars | Excel Discussion (Misc queries) | |||
How do I set different error bars per data point in a series | Charts and Charting in Excel | |||
can i colour a cell on basis of results of a formula e.g clour bl. | Excel Worksheet Functions |