Compare categories with a thin stem and a dot instead of a heavy bar. Upload a spreadsheet, size the dots and publish the chart for free.
A lollipop chart is a bar chart with the bar reduced to a stem and a dot. The ink falls where the value is, not across the whole distance to it, which keeps a long list of categories easy to read and makes small differences between large values easier to see. Each category gets a dot at its value, joined to the baseline by a line. A second column can size the dots, and a group column can colour them and build a legend. It suits rankings, survey results and any comparison across many categories.
Thin stems leave room to read twenty or thirty rows that would feel heavy as bars.
Dots at the end of a stem show small gaps between big numbers better than a block of ink.
Size each dot by another column, such as a sample size or a population.
A lollipop chart reads as less dense than a bar chart and sits well in a report or on a page.
A plain bar chart is just as clear and more familiar.
A stem implies length from the baseline, so a cropped axis can mislead.
A stacked bar or a donut chart shows composition. This chart compares separate values.
A dumbbell chart joins a start and an end value more clearly.
De uma planilha a um gráfico publicado, passo a passo.
Start the value axis at zero so the length of each stem tells the truth.
A ranked order is far easier to read. Use the sort setting in the Orientation tab.
Large dots hide the stem and cover neighbours. Lower the radius in the Dots tab.
One colour per category adds noise. Colour by a meaningful group, or use a single colour.
A bar chart in which each bar is replaced by a thin stem and a dot at the value.
Comece grátis com mais de 300 modelos. Sem cartão de crédito.
