Feature Request: Bar Chart Styling

Could you make it possible to add additional bar chart styling features?

Such as:

  • chart color
  • a highlight function (e.g.: highlighting the bar that is related to the current month)
  • showing the values per default and not on hover
  • 3D + shadow option

Additionally, if there are too many values to display a bar chart without looking ugly scaled, would you consider adding a horizontal/vertical scroll bar?

Also, I would like to mention that sometimes the bar-value shown seems to be incorrect. For example: I have €7.95 as the sum of values within a specific month. If I create a bar chart, it does not show me that value. As shown in the image below.

Lastly, can you consider adding a little popup displaying the sum of selected cells, like it’s done in Excel or Google Sheets? This would be helpful! :grinning_face_with_smiling_eyes:
2021-09-06_12h12_11

Thank you! :smiley:

We’ve noticed similar sounding issues with chart totals recently and made some changes. Tell me if my guesses are correct:

  1. The table shown on the left is a summary table.
  2. The chart’s underlying table is not a summary table, but rather the source (i.e. unsummarised) table of the summary table
  3. Changing the widget of the summary table to chart (or adding a new chart and setting the data to the same summary table grouped by the same columns) produces a chart that looks correct
  4. 0.34 and 0.74 are the values of single cells in the source table, e.g. adding 0.34 plus the other value(s) for 2020-08 gives 0.86.
1 Like

Hello Alex, thank you for your time!

Yes it is. It correctly summarizes the values.

I duplicated the chart in the following image. The upper one has a summary table (settings in the next image), the lower one utilizes the fundamental data table, not a summary table.

The upper chart’s summary table settings.

Unfortunately this didn’t create the expected result.
I added a summary table as a widget that displays year-month + number value.
I then added a chart with the base table displaying the year, month and number value. It’s grouped by first column “year”. I added the previous summary table to the select by function. This produces a single bar plot for each month. If I deselect this, then I get the normal bar plot with the incorrect sums. I assume I did something wrong :sweat_smile:

I’ll add this to the minimum example.

1 Like

It looks like your upper chart which is based on a summary table is not using the same summary settings as your original correctly working summary table. The chart is grouped by an extra column “Dividende Netto” which you’ve then used as your y-axis. But grouping by a column in a summary table means you’ll get a separate row for each value in that column, not totals.

Note that “group by first column” in charts means something quite separate from the group-by columns in summary tables.

2 Likes

Hello @alexmojaki,

I am not sure whether I understand you correctly - but that is no problem!
Let me briefly explain the bar chart output I would like to create:

  • x-axis maps to month
  • y-axis maps to interests after taxes / “Dividende Netto” ⇒ Here, I want the summarized values displayed as shown within the INTEREST_STOCKS table on the right side
  • I want to have a data series for each year

I’ve set year as the first column. If I uncheck the “Group by first column” option, I receive the following plot, which is not the output I want to create.

Do you have any suggestions on how to achieve this? :pleading_face:

1 Like

Sorry, that last comment about “group by first column” was just meant to be a sidenote, I distracted from the main point. The problem is that in this picture:

There’s a big difference between:

INTERESTS_STOCKS [by Month, Year, Interests after taxes] Chart

and

INTERESTS_STOCKS [by Year-Month]

and it’s not the Month, Year vs Year-Month part. You want the interest values to be summarized, but grouping by that column specifically means it won’t be summarized. Use it as a chart series, but not a group-by column for the summary table. Here’s what the correct settings look like:

Note the title of the chart:

INTERESTS_STOCKS [by Month, Year] Chart

3 Likes

Thank you, @alexmojaki for addressing my “thinking error”. I’ve emphasized it below.

I didn’t know that I don’t have to select all values that shall be displayed.

I made a short video how to resolve my issue: Grist - Creating the correct chart
This might be helpful for other people.

Thank you for your support, Alex! :+1:

3 Likes