AntBlabby8
Board Regular
- Joined
- Apr 18, 2002
- Messages
- 197
I am trying to create a stacked chart in Excel for Item A and Item B. Together, they are 100% of sales. I am showing, 2003-2007. Each Item for each has its amount of sales in $ that I need to show, so I have chosen the Data Table option, below each stack. The problem is that I want the Data Labels to be PERCENTAGES. So that it will show 40% in one and 60% in the other and so on. When I go to choose PERCENTAGE from Data Labels in Chart Options, it is clouded out, it won't let me do it. Does anyone know a workaround for this? I am on a deadline and this is the last piece I need to finish my presentation. Argh!