Select to view content in your preferred language

Multiple Series in a Line Graph

574
2
Jump to solution
11-20-2022 06:21 PM
LowellHood
New Contributor

Hello,

I am trying to create a line graph in ArcGIS Dashboards that shows a monthly crime trend. I am trying to make each line a different year with month on the x-axis and incident count on the y-axis, similar to this chart:

LineGraph1.png

However, in Dashboards the closest I can get is this:

LineGraph2.png

Is there a way to format it like the first chart? Any help would be appreciated. Please let me know if you need additional information.

 

Thank you

0 Kudos
1 Solution

Accepted Solutions
JenniferAcunto
Esri Regular Contributor

You cannot use a date field to get the look you want. If you reformat your data to include the following fields: Month, Year, and Value.

Screenshot 2022-11-21 063549.png

 

Then use the month field as your category field and split it by year. 

2022-11-21_6-31-54.png

 

To ensure the order of the months is correct, I would recommend using the numeric value and then using the categories label to set the month text.

Screenshot 2022-11-21 063650.png

 

- Jen

View solution in original post

2 Replies
JenniferAcunto
Esri Regular Contributor

You cannot use a date field to get the look you want. If you reformat your data to include the following fields: Month, Year, and Value.

Screenshot 2022-11-21 063549.png

 

Then use the month field as your category field and split it by year. 

2022-11-21_6-31-54.png

 

To ensure the order of the months is correct, I would recommend using the numeric value and then using the categories label to set the month text.

Screenshot 2022-11-21 063650.png

 

- Jen
LowellHood
New Contributor

@JenniferAcuntoThank you for the reply! I ended up doing what you suggested and it worked. I really appreciate the help!

0 Kudos