Charting data

Philip Arnfield

I have a sheet with 3,000 rows representing different jobs and recording the profit per hour for each job. I have sorted the jobs into customer groups and want to prepare a line graph for each customer group as illustrated below. Is this possible?

Genevieve P.

Hi @Philip Arnfield

The way I would do this is to create one Report per-Customer Name. Then select each individual Report as the source for each individual Chart Widget.

The Report will filter out the rows so it's only the relevant ones for each customer, and it will automatically add new rows as they're added to the source sheet.

Let me know if that makes sense or if you'd like to see some screen captures to illustrate how to do this!

Cheers,

Genevieve