Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Configuring Line Graphs in SSRS for color blind? Expand / Collapse
Author
Message
Posted Wednesday, December 19, 2012 3:10 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, April 02, 2014 12:25 PM
Points: 92, Visits: 326
Has anyone ever needed to make a chart (especially a line graph) in SQL Server Reporting Services user-friendly for color blind users? I've been brainstorming of various ways, but haven't come up with a solution yet.
Post #1398687
Posted Thursday, December 20, 2012 10:01 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, April 02, 2014 12:25 PM
Points: 92, Visits: 326
Bump.

Just thought I would check one more time.
Post #1399040
Posted Thursday, December 20, 2012 10:07 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, April 03, 2014 10:10 AM
Points: 2,792, Visits: 4,874
DataAnalyst011 (12/19/2012)
Has anyone ever needed to make a chart (especially a line graph) in SQL Server Reporting Services user-friendly for color blind users? I've been brainstorming of various ways, but haven't come up with a solution yet.



I don't think you have much options especially for "line graphs".
Your best bet would be playing with shades of black, but in lines, it will still be very hard to differentiate (even using very bold lines).
Would be better if you could make lines of different styles:

______________
---------------
- - - - - - - - - -

etc...



_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!"
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help
Post #1399041
Posted Friday, December 21, 2012 7:37 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 8:18 AM
Points: 640, Visits: 301
I have gone for the following strategy

1) Select a standard palette that does not mix reds with greens (If I needed to custom the colours myself *- The same don't show reds on the same chart as greens)
2) Label the lines / bars in such a manner that the legend is included in any tooltip


* - I only custom the colours myself if I will have several charts / graphs visible at the same time and I want to guarantee that the same colour is shown consistently across charts . I work in Health and I produce charts by team that show Attended / Did Not Attend / Provider Cancel / Client Cancel on the same report. In smaller teams there may not be any DNA's in the period that I am reporting for example , so I need to associate a color for attend, one for DNA, one for Client Cancel and one for Provider cancel
Post #1399414
Posted Friday, December 21, 2012 7:47 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, April 03, 2014 10:10 AM
Points: 2,792, Visits: 4,874

1) Select a standard palette that does not mix reds with greens
...


Is not as simple as that. There are many different types of vision deficiencies. You may need to not to mix yellow and blue, green and purple and many others...

Line labels would be definitely good idea (even for non-colour blind...)


_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!"
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help
Post #1399419
Posted Friday, December 21, 2012 7:54 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 8:18 AM
Points: 640, Visits: 301
Hi Eugene,
Yes, I am aware that there are many conditions of which forms of red / green are the most common. I have tried to provide something that provides something that looks really professional to most people and usable for all.

The original thought-process on dotted and dashed and continuous lines is excellent though and I would be interested if this got implemented
Post #1399424
Posted Friday, December 21, 2012 8:06 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, April 03, 2014 10:10 AM
Points: 2,792, Visits: 4,874
You can do it in SSRS.

Create a chart and select your series. Right-click series and select Series Properties.
Select Border. You can use function for setting different line styles.



_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!"
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help
Post #1399432
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse