creating charts
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Creating charts

Creating charts

resolvedResolved · High Priority · Version 2007

replyReply Wed 10 Nov 2010, 10:56Delegate Elishka said...

Elishka has attended:
Excel Intermediate course

Creating charts

Hello,

I'm trying to create an excel line chart where the line represents total volume (eg. of cars sold). Then the area underneath the line is split into block colours to represent how the gross volume is divided (eg. between different car makes).

Is this possible? Would really appreciate any pointers.

Thanks very much,
Elishka

For upcoming training course dates see: Pricing & availability

replyReply Wed 10 Nov 2010, 18:21Trainer Rodney said...

RE: Creating charts

Hello Elishka,

Hope you enjoyed your Microsoft Excel course with Best STL.

Thank you for your question regarding Excel line/bar charts. It will be most helpful if you can send me a small file with the data you require to be converted into a chart. I will send you a blank Excel file which you can fill in and return to me as soon as you can. I will then create the chart for you with an explanation as to how it was done.

I hope this is OK with you.

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer

Attached files...

Charts for Vehicle Sales.xls

replyReply Thu 23 Dec 2010, 12:55Trainer Nafeesa said...

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Thu 30 Dec 2010: Automatically marked as resolved.

 

Please browse our web site to find out more about
excel training seminar and other Microsoft training courses.

Excel tip:

COUNT function vs COUNTA function

The COUNTA function works in the same way as the COUNT function, except that it will count cells that contain text (labels) and also cells that contain numbers (values). The COUNT function will only count cells that contain numbers. Blank cells are not counted by either the COUNT or the COUNTA function.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard