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

exce+training - charts

Forum home » Delegate support and help forum » Microsoft Excel Training and help » exce+training - Charts

exce+training - Charts

ResolvedVersion Standard

Anna has attended:
Excel Introduction course

Charts

How do you change the layout of a chart

RE: Charts

Hi Anna, Thanks for the post, to answer your question; have your worksheet with the chart on it open, and click on the chart to select it, you will notice that the Menu Option for Data is now reading Chart; from this menu choose Chart Type, this will open a dialog box which will allow you to choose a different type of chart, proceed and select your preferred layout of the chart.
If you wish to view the chart from a different perspective, whilst the chart is selected, from the Chart Menu choose Source Data and select either Rows or Columns to change the view.
Advanced Charting is covered in our Excel Intermediate Course.
I hope that helps,
regards Pete

Excel tip:

Using the Quick Access Toolbar in Excel2010

The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010.

You will find the Quick Access Toolbar in the top-left side of the window. To begin, click the Customize button (it's the little black arrow at the end of the toolbar).

Simply click the commands you want to include.

Virtually any command can be added to the Quick Access Toolbar. Click the More Commands option and a new window will open from where you can browse the commands including those not on the ribbon.

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.11 secs.