Hello,
I have an .xlsx that gets displayed as a line chart, I would like to know if it's possible to add an overlapped circle with a color code depending on column B of the spreadsheet
I manually added the color code in the .xlsx and in the screenshot below
Regards,
Isaac
Aug 16, 2017 3:36 PM
I converted the Line Type to a number (logic in [Line Type Number]) then used some min/max logic to figure out what the proper colour was:
Let me know if you have any questions
Aug 16, 2017 4:14 PM
Hey Isaac,
Sure can! With a dual axis chart you can add the circles. I've attached a revised version of the workbook you provided with instructions. That'll get you half way there - to a view with the line and the dots colored by transaction type. But a different dot will display for each account transaction each day.
To get the color to roll up the way you show in your screenshot, instead of individually for each transaction by account...I think you might need an LOD calculation, which is regretfully not one of my strong suits. Maybe another Community member can assist for the win here?
Thanks a lot Chris!
That's exactly what I was looking for
@AB Commendatore, you can check CM solution in case you want to see how he solved it, it worked great for me
Regards,
Isaac