Bar chart through a table 💫
In some systems, bar charts can be tricky:
– When the chart is too long, category labels don’t fit and start disappearing.
– You often can’t left-align the labels, which makes the chart harder to read.
One neat workaround is to build the bar chart through a table.
In Excel, you can do this with Conditional Formatting + Data Bars (see example in the image). This approach also works well in tools like DataLens.