chart creatiom

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Chart creatiom

Chart creatiom

resolvedResolved · Low Priority · Version 2003

Susan has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course

Chart creatiom

Can you mix chart styles
i.e bars and lines in 1 graph?

RE: chart creatiom

Hi Susan,

Yes you can create a chart with a mix of 2 chart types.

1>Create the Bar chart as normal with the two of more Data Series.

2>Right-click on the Data Series you want to change and select Chart Type.

3>Change to Line Chart.


Follow the same procedure to change the format of the Data Series if you want by selecting Format Data Series on step 2.


Regards,

Ben

 

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:

Large Icons on toolbar

You can make the buttons on your toolbars bigger by going to Tools / Customize / Options / select Large icons.

View all Excel hints and tips


Server loaded in 0.17 secs.