creating charts

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

Creating charts

resolvedResolved · High Priority · Version 2007

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

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

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.

 

Training courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Removing the Ribbon from view in Excel 2010

At times when you want to view the whole spreadsheet, try double clicking on the ''Home'' tab on the ribbon which will hide the ribbon from view.

View all Excel hints and tips


Server loaded in 0.08 secs.