Please enable JavaScript.

Coggle requires JavaScript to display documents.

Excel CG training (Introduction (Creating a chart from a dataset (general…

- - - - only select relevant areas of data
      - multiple areas must have same heights
      - CTRL + select to select multiple non-adjacent areas
      - solid block
      - exercise 1
    - - show different methods
        
        chart design tools
        
        right click on chart
    - - recommended charts
      - most common charts group of icons
        
        look at preview
    - - three buttons to right of chart
        
        First button: Chart elements
        
        can be selected and modified separately
        
        copy paste text
        
        format text (click twice)
        
        move elements
        
        modify columns
        
        select all columns by clicking on one
        
        select one column by clicking on it when all are selected
        
        change colours and borders
        
        eg chart title, legend, axis names, axes, columns etc
        
        Second button: Chart styles
        
        also show how to access via chart tools
        
        hover to preview
        
        Third button: data filter
        
        don't forget to click "apply"!
        
        also via select data button in chart tools
    - - clustered
      - stacked
        
        similar to clustered but columns are stacked on top of each other
      - 100% stacked
        
        column height not based on values but on percentage vertical pie chart
        
        need to be careful what values to include
        
        similar to clustered but columns are stacked on top of each other
      - switch rows and columns
      - Pie charts
        
        Clustered bar charts
        
        scale on axes
        
        for very large numbers change display unit to thousands, millions etc.
        
        based on values in dataset by default
        
        similar to clustered column chart
        
        add gridlines
        
        swap axes
        
        insert arrow (insert>illustrations>shapes)
        
        add data labels displaying the series name
        
        Scatter charts
        
        right click on data point then format data series to change size/shape/colour of datapoint
        
        add trendline (right-click on data point)
        
        right click to edit
        
        colour
        
        thickness
        
        dashing
        
        equation etc
        
        line charts
        
        use with formulas
        
        select data (hor value labels)
        
        add error bars
        
        right click on horizontal value labels, select error bars>more options
        
        1 more item...
        
        Combo charts
        
        choose the two axes option
        
        copying charts in other apps
        
        2 more items...
        
        click and drag a section
        
        change layout (use quick layout in chart tools)
        
        change data labels (position, colour)