Here we'll start off with a simple real life example, just to get our feet wet. Watch to see the easiest way of setting up charts in Excel.
Text00:16 Learn to set up a chart from scratch. This video addresses the issues that may arise and how to avoid or get around them. Be sure to watch all the way through!
02:13 Select the element, such as the Title element, type "=" and select the cell you want it to reference. You won't see the formula being written on the spreadsheet within the element, BUT check out the formula bar and you'll see it being written there.
02:50 Depending on how you set up the table your chart is sourcing, Excel might not understand what you want listed in your legend, so Excel will use Series1, Series2, ect as a default. Check out this video segment to learn how to fix this within the "Select Data Source" dialog box. You will also learn the best way to set up your table, so you won't need to go through the pain of manually developing your legend.
04:43 Learn this simple trick to quit wasting time figuring out how to display the data you want in a chart.
06:57 Similar to pressing Ctrl+1 outside of a chart to display the format cells dialog box, if a chart is selected and Ctrl+1 is pressed, Excel will pull up the Charting Task Pane. The element selected when the shortcut keys are pressed determines the options shown in the task pane. It's easiest to first select the element you'd like to edit and THEN press Ctrl+1.
VideoGIF
Charting-Outlines-1.xlsx