Forum Discussion
Define Gridlines Based on Bin Values from Sort
I have a spreadsheet sorted into bins by a custom list - day of the week. The number of elements per day is not uniform and the sort type is not critical to this suggestion. I created a chart ...
Hi Hans. Thank you for the quick response and the advice. If I followed your directions correctly, I now have a spreadsheet with the cells in the data tab's Day of Week column having a border line above each day value. It did not translate into the chart where I hoped to add gridlines between the days of the week.
I anonymized the data and attached the spreadsheet in case you or someone else has any suggestions.
added a blank row between the days so that a blank space replaces the gridline;
what is the expected result?
the chart from Date has grid.
the other from Day of Week no grid.
which one is your expected result?
how about online charts like echarts?
what is the expected result?
the chart from Date has grid.
the other from Day of Week no grid.
which one is your expected result?
how about online charts like echarts?