Line Chart

[BRRLL99]

Hi 

I have Following data

Costs	YEAR_1	YEAR_2	YEAR_3	YEAR_4	YEAR_5
Total Costs	90	150	250	250	250
Total Benefits	90	200	350	550	700

Expected Out:

Same Type Markers for both lines

[DataNath · Accepted solution]

Hey @BRRLL99, there's a few steps needed here.

1) You'll need to transpose your data so you get running name/continuous value fields that you can use for the axis:

2) In the Interactive Chart you'll need to create a new layer, make it a line chart and select your measure for X/value for Y:

3) Now, to split the chart into the 2 cost types, you'll want to go to Transforms > Split > Enabled > By [Costs] like so:

The end result will give you this:

If you want the dots along the lines as shown in your example, just got to Layer > By Type > Show > Points:

[JamesCharnley]

To add to the above post, if you specifically wanted the marks on the line too, you'll need to add another layer with the same settings that's a scatter instead of a line on top.

Edit: Above post was edited to make this comment obsolete. I have just learned something new about the interactive chart tool!