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

creating charts

ResolvedVersion 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.

Excel tip:

Using Excel's MODE function

Use Excel's MODE function to display the most common value present in a particular range of cells.

The Mode function looks like this:

=MODE(cell range)

As an example, if 35 is the most commonly recurring number in a particular cell range, then the function will display 35.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.19 secs.