ruthhacche
Board Regular
- Joined
- Sep 22, 2017
- Messages
- 84
I have a simple line chart. I have a column in my data that is True/False. Is there any way to make datapoints on the line that are True a different colour?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
PBI visual line chart - data markers
- Thread starter ruthhacche
- Start date
offthelip
Well-known Member
- Joined
- Dec 23, 2017
- Messages
- 3,252
- Office Version
- 2010
- Platform
- Windows
I have done something similar I produced a KAGI plot see:Kagi chart - Wikipedia
I used an X Y plot and used 2 series which overlap each other:
The series 1 data is in column K and L and the series 2 data is in M and N
I used an X Y plot and used 2 series which overlap each other:
The series 1 data is in column K and L and the series 2 data is in M and N
Upvote
0
ruthhacche
Board Regular
- Joined
- Sep 22, 2017
- Messages
- 84
brilliant - thank you for your help.
Upvote
0
Similar threads
- Question
