Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Open your exported EVM template in Google Sheets.

  2. Double click the cell where the chart was originally located in Excel. You'll likely see blank data instead of the chart.

    Знімок екрана 2024-03-11 о 14.10.42.png

  3. In the "Series" section, define the date range for your chart data.

  4. Here's how to do it:

    • Insert in the “Data range” section information about your data ranges

    • You can copy and insert this values - D30:D350, F30:F350, H30:H350, B30:B1000

    • In the "Series" section of the chart editor, locate the date range settings.

Use this picture as a reference to apply the date ranges for each data series.

...

X-axis

B30:B1000;

Series

D30:D350;

F30:F350;

H30:H350.
*Follow the same sequence

Use this picture as a reference to apply the date ranges for each data series.

...

Once you've defined the date range for all series in the chart Google Sheets should now generate your chart based on the data you selected.