Serial Chart - Fill opacity and Connect gaps excluding certain data points
Hello
I'm trying to make a time vs. company fee chart to display how my company's consulting fee's have fluctuated over the years (I'm working with mock values for now).
I would like it to look something like this:
I attempted to follow the same process with my fee values. However, when I go to 'Series' -> 'Type' -> 'Line' and then turn on 'Connect gaps' this occurs:
The grey points are the only two projects that have the same company fee (15,000,000) and they are the only two points that connect. The second problem is when I adjust the 'Fill opacity' only half the points are included in that fill.
My two questions are:
1: Is it not possible to 'connect gaps' when you have two or more points with the same value?
2: Why are only half the data points included in the shading and the other half excluded? I've been trying to play "spot the difference" to determine what the unshaded points have that that unshaded points don't but I haven't been having much luck - perhaps there is something I've been overlooking in my survey responses that may lead me to some solution.
Any suggestions would be helpful. Thanks !
It is the way you have your data structured. Points will connect within the same series, but not across series. You have your dashboard set up to have multiple series, the majority of which only have a single point so there is nothing to connect. It looks like each salary amount is it's own series. You will need to set up your data so all of your values are in the same series.
Or if you are trying to compare rates across different services you would split your chart by the service in the data tab.
