98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel london - Chart Calcs
excel london - Chart Calcs
Resolved · Low Priority · Version Standard
Thu 18 Jan 2007, 19:21Delegate Bowen said...
Bowen has attended:
Excel Advanced course
Chart Calcs
I am trying to use a 3-D Pie Chart using two figures, 71 and 417 which are 17% and 17% and 83% respectively. However when asking for Excel to add these values they pop up as 15% and 85% and I do not understand why or how to rectify this.
Fri 19 Jan 2007, 09:11Trainer Tom said...
RE: Chart Calcs
Hi Bowen
Thank you for your question. To help us answer your question. We need a bit of clarification. It was stated you had 2 data values of 417 & 71 respectively and thie pie chart returns 85% & 15%, which is accurate according those figures. However then it was mentioned that you wanted percentages shown. Eg 17%, 17%, 83%. The question is how many data values do you have?
If the chart is only looking at 2 data values it will only show 2 percentages. Maybe look at your data series that are included in your chart data.
Please send us your data the chart is based on if you need need further assistance.
Look forward to hearing from you.
Thank you for using the forum
BEST Training
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Hiding and unhiding columns using the keyboardCTRL + 0 hides your columns and CTRL + SHIFT + ) unhides them although you would need to highlight the column letters either side as per normal |
