I would like to keep the percentage values but remove the percent sign
from the value axis of a 100% stacked bar chart. Can it be done?
Thanks
Anne
Do you really need to get rid of the percentage sign? I think it would make
the chart more readable and easier to interpret if it were there. Tufte would
agree.
--
Thanks,
Christopher
This posting is provided "AS IS" with no warranties, and confers no rights.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______
<aon...@gmail.com> wrote in message
news:b024225a-eb94-4262...@v3g2000hsc.googlegroups.com...
Jon, it's a brilliant suggestion to use an intermediate table to
generate the graph. Thanks a million!
Anne
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______
<aon...@gmail.com> wrote in message
news:ddd935f7-0d52-424e...@e10g2000prf.googlegroups.com...
yea!
Tina
> On Monday, March 03, 2008 2:28 AM chscot wrote:
> I played around for a while, but could not find a format code to make 80%
> display as 80. I could not get this to work on the sheet cells format
> either. You could right click the value axis, choose Format, choose Number
> and type in the format code .00 to make 80% display as .80 but it sounds like
> you don't want that.
>
> Do you really need to get rid of the percentage sign? I think it would make
> the chart more readable and easier to interpret if it were there. Tufte would
> agree.
>
> --
> Thanks,
> Christopher
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
> "aon...@gmail.com" wrote:
>> On Monday, March 03, 2008 9:32 AM Jon Peltier wrote:
>> If you want to keep the original data unchanged, but plot different data,
>> then use another range, put in a formula like =100*B2 to convert B2 from a
>> percentage to a number, and use this data in your chart. Put it on another
>> sheet if your boss would otherwise get confused.
>>
>> - Jon
>> -------
>> Jon Peltier, Microsoft Excel MVP
>> Tutorials and Custom Solutions
>> Peltier Technical Services, Inc. - http://PeltierTech.com
>> _______
>>
>>
>> <aon...@gmail.com> wrote in message
>> news:b024225a-eb94-4262...@v3g2000hsc.googlegroups.com...
>>> On Monday, March 03, 2008 10:17 AM Jon Peltier wrote:
>>> Well, I wouldn't say brilliant, but it sure is a lot easier. Worksheet space
>>> is cheap, and brainpower to force Excel to do what it doesn't want to is
>>> expensive.
>>>
>>> - Jon
>>> -------
>>> Jon Peltier, Microsoft Excel MVP
>>> Tutorials and Custom Solutions
>>> Peltier Technical Services, Inc. - http://PeltierTech.com
>>> _______
>>>
>>>
>>> <aon...@gmail.com> wrote in message
>>> news:ddd935f7-0d52-424e...@e10g2000prf.googlegroups.com...
>>>> On Wednesday, March 05, 2008 5:41 AM aonnim wrote:
>>>> Hi,
>>>>
>>>> I would like to keep the percentage values but remove the percent sign
>>>> from the value axis of a 100% stacked bar chart. Can it be done?
>>>>
>>>> Thanks
>>>> Anne
>>>> Submitted via EggHeadCafe
>>>> SQL Operations on a Text File with ADO.NET
>>>> http://www.eggheadcafe.com/tutorials/aspnet/37ed9e1b-c5de-4c0b-afbe-d8f78f9a6ecf/sql-operations-on-a-text-file-with-adonet.aspx