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 Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
wrote in message
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?