SUBSCRIBE to Windows IT Pro Magazine & SAVE 30%     Register today for your FREE 'To The Point' SharePoint eNewsletter
     
     

Simple steps to professional charts

Create a chart with the Chart Wizard
  • Select the data you want to portray
  • Remember CTRL+select allows you to select non-adjacent ranges!
  • Click the Chart Wizard button
  • Click Finish

    or

    Click Next and step through the Chart Wizard



Edit the chart as a whole
  • Click to select the chart. You can now move, size, or delete the chart.


Print just a chart
  1. Select the chart
  2. Choose File → Print


Edit parts of the chart
  • Use keyboard & mouse shortcuts to move, copy, size, or delete chart elements or
  • Use the tools on the chart toolbar (View → Toolbars ? Chart it is not visible) or
  • Right-click on something you want to change or
  • Double-click anything to change it. A dialog box will appear with all of your options for that piece of the chart.
    This is the most valuable way to approach charts: Double-click anything to change it.
  • The Fill Effects... button allows you to create stunning charts


Chart tips
  • Drag data on to the chart to add it (or select the data, choose Copy, select the chart, choose Paste).
  • Double-click on a column (or bar or...) or background and click Fill Effects. Click Picture and you can fill with a picture!
  • Two single clicks isolate one piece of a group (e.g. a piece of a pie chart). You may then edit that element (drag, delete, or double-click it).
  • Create a 3-D chart type then select the chart until you see handles on the corners of the cube. Drag that corner to see your data from a different perspective.