740 likes | 902 Views
06. Excel Charts. File -> Open -> 06b-datastart.xlsx. Click on column header A to select the Date column. While holding Ctrl on your keyboard, click on column header E and F. Click on Insert -> Line -> 2-D Line. Displays a line graph of the indices both starting at 1,000.
E N D
While holding Ctrl on your keyboard, click on column header E and F
Right-Click with mouse on left axis and click on Format Axis
Untick box which saysShow the legend without overlapping the chart
Now have a neatly formatted chart that can be copied to Word or Powerpoint
While holding Ctrl on your keyboard, click on column header E and F
We often want to find how the daily changes in one company are related to changes in the S&P500