Line Charts in Dashboards - Need two lines on one chart

Paul Newcome

@Angie Hatfield Are you able to provide some screenshots for context?

Brian_Richardson

@Angie Hatfield there's a couple of items to try. Charts aren't limited to one row, so it's a setup issue that you can likely resolve. Also, if these steps don't work then please post your summary sheet screenshot as well as the chart and the chart settings.

I also highly suggest using a report for charting instead of a sheet. Charts will chart the entire report so you will not need to mess with the chart ranges as your data changes. Also, charts will chart the group and summary data (first level) on a report which can be leveraged to ensure that your charts have all the data you expect without blanks and spaces as we were discussing above.

If you're charting a report, the grouping ends up being the series column, be sure to select the primary column where the grouping happens to use as your "first column as series" in the chart and ensure that switch is on in the chart settings.

Sometimes I also will try flipping the "switch rows and columns" which works particularly well if your charting data is spread over multiple columns.

Angie Hatfield

@Paul Newcome Thanks for looking

Angie Hatfield

@Brian_Richardson Yes, tried a report with same result. Tried keeping the primary within and outside of range.

dhall

Hey Angie,

I think the Line Chart is not showing both rows because the data is exactly the same in both rows. Therefore, it only shows one because it is directly on top of the other.

If you modified the numbers for Org 2 so they are not the same as Org 1, do you get different results?

Daniel

Angie Hatfield

@dhall You are right, that was it and it did solve it. I guess a bar chart will be best for this.

That's the only thing I hadn't tried. Thanks so much, you're awesome. :)

Paul Newcome

EDIT: I hadn't seen @dhall's response before typing. Glad you got it sorted.

Your numbers for the two rows are identical. Technically the second line is there, but it is covered up by the first because they follow the exact same path. If the numbers on the two rows were different, you would see a second line where they aren't overlapping.