Solutions Through Learning
Callback
Sign in
Basket
Call us on 0207 987 3777 or Search our website
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Charts
Resolved · Low Priority · Version 2003
Katherine has attended:
Excel Introduction course
How do you select the correct data for a chart?
Hi Katherine,
Thank you for your question.
In an ideal world the data should be arranged in columns with field headings.
If you had the following data below from A1 to B5:
Name Sales
Simon 23000
Desmond 35000
Miriam 40000
Alicia 50000
Select the entire range including the headings as this automatically names the Value series as Sales.
I hope this answers your question.
Regards
Simon
Wed 17 Mar 2010: Automatically marked as resolved.
|
|
Excel tip:Apply Autosum with keyboard shortcutIf you press Alt and = at the same time, it applies autosum. |
TrustScore
4.9
/ 5
2224 reviews
Connect with us:
We will call you back
Call for assistance
Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
We'll call during UK business hours
Server loaded in 0.08 secs.
