How do I create a graph with multiple data points?

Messiah · ‎08-19-2022

I'm being asked to create a graph to show number of incoming tickets vs number of tickets closed over time. I'd also like to get the totals for each column to be displayed above each bar.

Thanks in advance.

Uncle Rob · ‎08-20-2022

Something like this?

STEP 1 - Make a report that's a trend report with your preferred visualization (I picked spline)
Conditions: Created on This year (or whatever). Don't group. Trend by Created (or whatever datetim)

STEP 2 - Add a dataset to the report. This is the secret to putting two different things on one chart.

STEP 3 - The new dataset is a report. Fill it out the same way. You'll be constrained to Trend because that's what the "parent" report is. Conditions of "Closed This Year" (or whatever). No Grouping. Trend by Closed Date. Pick whatever visual (I used splines)

Save that and you're back to the "parent" report, except its got both splines.

Take care though: name the "Parent" report as if it does both things.

"BUT HOW DO I GET THE NUMBERS AT EACH DATA POINT?
Under the Style tab of each report. Check Display

View solution in original post

GoliaFF1979 · ‎04-17-2023

First, you'll need to input your data into Excel. You can make two columns, one for incoming tickets and one for closed tickets, and then add the corresponding data for each month or time period. Then, you can use the chart wizard to create a bar chart with both data sets. To display the totals for each column above the bars, you can add data labels to the chart. This will allow you to see the total number of incoming and closed tickets for each month. If you're looking for more tips on creating graphs in Excel, check out this article: https://www.wallstreetoasis.com/resources/excel/study/types-of-graphs. It has some great examples of different types of graphs that you can create in Excel, and should be a helpful resource for you!