7.4. How to create a chart based on a listing

  1. to create a chart based on a listing, the following conditions must be fulfilled:

    • It must have at least 2 columns

    • Each listing cell content must begin with an expression

  2. put cursor inside listing

  3. choose from popup menu Change Into Chart

  4. Listing will be changed into chart according to the following rules:

    • it will be a bar chart

    • data on the chart will be labeled with expression from the first column

    • following chart series will correspond to following column expressions starting from the second one

    • the chart title is the text from the first column header in a listing

    • series names come from the following column headers

    • label color will suite the font color in particular columns

    • series color will suite the font color in particular columns

    • data sorting and filtering will be kept in the listing

    • other information is going to be lost