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

Chart creatiom

ResolvedVersion 2003

Mon 29 Sep 2008, 15:38 Delegate Susan said...

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?

Wed 1 Oct 2008, 11:04 Delegate Ben said...

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

98.7 % recommend us

More live stats...

Training information:

Excel tip:

How to Remove Duplication's from a selection of data in an Excel 2010 Worksheet

It would take far too much time to scan through rows and rows of data to find and remove duplicate data. So, here's how to do this using a much more efficient method:-

1) Select the data that might contain duplication's
2) Click the ''Data'' tab
3) Go to ''Data Tools'' and click ''Remove Duplicates''
4) A box will appear. Tick the boxes of the columns that you want to use to check for duplicates. Finally, click ''OK.''

View all Excel hints and tips

Chart creatiom

Chart creatiom

RE: chart creatiom

Excel articles

Excel tip:

How to Remove Duplication's from a selection of data in an Excel 2010 Worksheet