How can I create a chart on the dashboard with multiple lines showing trends?
I have a sheet below that will be updated every month. The goal is to see trends throughout the month. There will be separate charts for the last 2 columns (Claims and $ Value). What my thinking is having Month on the Horizontal Axis and Claims or $ Value on the Vertical Axis. There will be 22 lines, each representing a warehouse. I want to avoid having to create 2 seperate sheets (one for claims and one for $ Value). Any ideas on how to achieve?
Example of chart I am thinking of creating: