Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
Do you know if it's possible to remove these lines? I've tried changing the scale to wide and completely removing the axis but they're still there.
Thanks!
Hi Julian,
Given all the crazy stuff you can do in the chart styling (who wants thick borders around each bar?) this feels like something that should be under there, but it isn't.
I don't know if it can be hacked by inserting CSS into the sheet?
The fact that you can change things in a Sense Theme makes me think it should be, but the theme will affect all charts and not just a specific one. Whether you can find the handle for a single chart and then apply the CSS just to that I don't know.
I believe the theme elements will be as follows:
{
"_inherit": false,
"_variables": {
"@AxisMajorColor": "#ffeeee",
"@AxisMinorColor": "#ffeeee"
}
}
Having a play with @barryharmsen and BitMetric's excellent https://www.sensetheme.com/ may be a good starting point.
Good luck!
Steve
Hi Julian,
Given all the crazy stuff you can do in the chart styling (who wants thick borders around each bar?) this feels like something that should be under there, but it isn't.
I don't know if it can be hacked by inserting CSS into the sheet?
The fact that you can change things in a Sense Theme makes me think it should be, but the theme will affect all charts and not just a specific one. Whether you can find the handle for a single chart and then apply the CSS just to that I don't know.
I believe the theme elements will be as follows:
{
"_inherit": false,
"_variables": {
"@AxisMajorColor": "#ffeeee",
"@AxisMinorColor": "#ffeeee"
}
}
Having a play with @barryharmsen and BitMetric's excellent https://www.sensetheme.com/ may be a good starting point.
Good luck!
Steve
Yeah, messing with the CSS for the whole sheet seems kind of weird for something that simple!
Thanks a lot, Steve!
There is so much customisation that it is hard to know where those settings are, but this is actually possible.
First you have to switch Grid line spacing from auto to custom and then from dropdown pick no lines.
I checked it on bar chart and combo chart and it works in both.
Simple as that.
cheers
Wow, I was expecting the option to be somewhere, but i wouldn't have guessed at there.
Doing that, do you then lose control of how many values appear on the axis? It feels like the number of lines and the spacing should be independent settings.
Steve
number of values on axis is independent. It is in axis setting. Funny enough this setting also controls amount of white space / ceiling "above" bars, so when aligning charts next to each other it is worth making sure they have the same setting so they dont look out of place.
cheers