Forum Discussion
line chart - color gradient
I am trying to look at variation of ridership values with month. I have plotted data for 10 years but all the lines appear in different colors which makes it little difficult to understand unless you have legend opened on the side
Is there any way by which I can change the color of my years based on a gradient. For example all the lines are shades of green; 2006 being dark shade of green, 2000 being lighter shade of green and 1996 being the lightest.
You could do it in R, though you lose interactivity back into your dataset etc. Something like:
library(ggplot2) # Needed for ggplot # Avoid having to reference dataset$ each time in function calls attach(dataset) #Plot the Count dataset by Month and Year, with Year to set the fill colour ggplot(dataset, aes(x=Month, y=Count, group=Year, colour=Year)) + #Use lines on the plot geom_line() + Restrict the colur hue to (around) the green range scale_color_hue(h=c(90,180))
You may need to fiddle with the scale_colour_hue parameters to get exactly what you want.
5 Replies
Hi vijaybansal3000,
You could select the paint roller icon and expand "Data colors" and manually assign different gradients of 1 or more colors. It's not the ideal way, but it will accomplish what you want.
You could do it in R, though you lose interactivity back into your dataset etc. Something like:
library(ggplot2) # Needed for ggplot # Avoid having to reference dataset$ each time in function calls attach(dataset) #Plot the Count dataset by Month and Year, with Year to set the fill colour ggplot(dataset, aes(x=Month, y=Count, group=Year, colour=Year)) + #Use lines on the plot geom_line() + Restrict the colur hue to (around) the green range scale_color_hue(h=c(90,180))
You may need to fiddle with the scale_colour_hue parameters to get exactly what you want.
Thanks Anonymous. This seems to be a good way. Though I would have loved this as a feature inbuilt in PowerBI itself without going to R code.
Thanks Anonymous. I am looking for some way like below which can be acheived in Tableau.
