06 excel charts
Download
1 / 71

06. Excel Charts - PowerPoint PPT Presentation


  • 105 Views
  • Uploaded on

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.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' 06. Excel Charts' - oni


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

File open 06b datastart xlsx
File -> Open -> 06b-datastart.xlsx


Click on column header a to select the date column
Click on column header A to select the Date column




Displays a line graph of the indices both starting at 1 000
Displays a line graph of the indices E and Fboth starting at 1,000


Right click with mouse on left axis and click on format axis
Right-Click with mouse on left axis E and Fand click on Format Axis





Click close
Click Close E and F


Right click with mouse on x axis and click on format axis
Right-Click with mouse on X axis E and Fand click on Format Axis





Untick box which says show the legend without overlapping the chart
Untick E and F box which saysShow the legend without overlapping the chart



Select border color solid line black
Select Border E and FColor -> Solid Line -> Black


Click close1
Click Close E and F


Click on legend and drag to empty space on top left
Click on Legend and drag E and Fto empty space on top left


Right click on plot area and select format plot area
Right-Click on Plot Area and select E and FFormat Plot Area …



Select border color solid line black1
Select Border E and FColor -> Solid Line -> Black


Click close2
Click Close E and F


Right click on chart area and select format chart area
Right-click on Chart Area and select E and FFormat Chart Area …



Click border color no line
Click Border E and FColor -> No Line


Click close3
Click Close E and F






Save as customlinechart
Save as or CustomLineChart



Click on chart and press del on keyboard to delete
Click on Chart and or press DEL on keyboard to delete


Click on column header a to select the date column1
Click on column header A or to select the Date column





Click ok
Click OK E and F




Challenge create a scatter graph of returns

Challenge: E and FCreate a scatter graph of returns



Type applereturn in h1
Type are related to changes in the S&P500AppleReturn in H1


Type spreturn in i1
Type are related to changes in the S&P500SPReturn in I1


In h3 type b3 b2 b2
In H3 type are related to changes in the S&P500=(B3-B2)/B2


In i3 type c3 c2 c2
In I3 type are related to changes in the S&P500=(C3-C2)/C2


Select cells h3 and i3 and press ctrl c on your keyboard
Select cells H3 and I3 and are related to changes in the S&P500press Ctrl+c on your keyboard


Paste formula down remainder of dataset
Paste formula down remainder of dataset are related to changes in the S&P500


Click on column headers h and i
Click on column headers H and I are related to changes in the S&P500


Click on format format cells
Click on Format -> Format Cells… are related to changes in the S&P500


Click on percentage 2 decimal places
Click on Percentage -> 2 Decimal Places are related to changes in the S&P500


Click ok1
Click OK are related to changes in the S&P500



Click on insert scatter
Click on Insert -> Scatter and select columns H and I


Click on chart1
Click on and select columns H and IChart


Click on layout horizontal value axis
Click on and select columns H and ILayout -> Horizontal (Value) Axis


Click on format selection
Click on Format Selection and select columns H and I


Click on axis labels low
Click on Axis Labels: Low and select columns H and I


Click close4
Click Close and select columns H and I


Choose layout series applereturn
Choose Layout -> Series “ and select columns H and IAppleReturn”


Click format selection
Click Format Selection and select columns H and I



Click close5
Click Close and select columns H and I


Choose layout series spreturn
Choose Layout -> Series “ and select columns H and ISPReturn”


Click format selection1
Click Format Selection and select columns H and I


Click marker options built in size 3
Click Marker Options -> Built-in -> Size 3 and select columns H and I


Click close6
Click and select columns H and IClose


File save as 06c datacompleted xlsx
File -> Save As -> 06c-datacompleted.xlsx and select columns H and I


Challenge
Challenge and select columns H and I

  • Format the rest of the graph to make it neater

    • Date format on axis

    • Legend

    • Plot area

    • Chart area

  • Save as CustomScatterGraph


ad