Need help with Serial Chart - Stacked
I got on with ESRI Tech Support but the person assisting me couldn't figure it out and suggested I post here in the community to see if I could get some help.
The bar chart below represents the total sum of kW per power circuit on our system. For each circuit, I have a field tracking KW of solar customers, represented by the orange bars below. I also have been given what the total sum of KW is allowed on each circuit.
In my table, I've create a new field that I called "Allowed DG (KW)" and then I added the maximum KW to each circuit. I went to one record for each circuit and added the "Allowed DG (KW)" maximum for each. Then I followed the solution provided here but can't get the results I want.
In my Data Options for the Serial Chart, I selected "Grouped Values" on my Circuit field. Then "Split By Field" on "Allowed DG (kW)". For Statistic "Sum" is selected and for Field I've got "kW".
In the Series tab for the Serial Chart, I've selected "Stacked 100%". But after doing that, it looks way different than when I was hoping it would.
I have attached the csv of my data that I'm working with.
Does my question make sense or how can I help you understand my problem to help me get to my solution?
Any suggestions?
Thanks!
