Charting data

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?


Answers

  • Genevieve P.
    Genevieve P. Employee Admin

    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!