Multi Line Graph on Dashboard

Alisia Anderson

How do I arrange the data so that I can use the multi-line graph on the dashboard? I have 3 columns for sales (3 weeks out, 1 week out, 1 day prior) and 3 columns for projections (3 weeks out, 1 week out, 1 day prior). I'd like to have the dates on the bottom axis and the # units on the vertical axis and (2 different color lines or bars - ones for sales, one for projections).

Matt Johnson

Hi @Alisia Anderson

I use a metric sheet or calculation sheet between the actual data and the dashboard. Below are couple screen shots on how you could arrange the data for a graph. I would use a cross-sheet SUMIF formula to get the totals onto the metric sheet but that really depends on what other information is available. I hope this helps.

Alisia Anderson

That worked - thank you!!!