I have a lot of Excel data I need to prepare graphs for and am not sure where to start. How do you recommend I get started?
One new feature of Excel 2010 is the ability to create “sparklines” for individual rows of data. Sparklines are a simple way to show individual “mini” graphs in cells next to your numbers. Check out this free short training course.
Otherwise, most people use charts based on data in a spreadsheet, or from pivot tables. You need to identify the data you wish to place in chart and determine which type of chart to use, and then customize with a number of options. There are many types of charts that can be used, based on the type of data you need to analyze. Here is a basic training course in charts.
For a “crash” course in creating and working with a variety of Excel Charts, come to the ITS mini-session on Monday, Nov. 26 from 1 to 2:30 p.m. You’ll work on a variety of examples and learn to work with a charts of all types. You’ll also learn what charts to avoid. We will also have a drop in Help session following from 2:30 to 3:30 p.m. for those who want more one-on-one help with their projects.