The area chart shows the evolution of the available metrics over time. It requires a Date column in the dataset.
The plot is run for each dimension.
By clicking on a legend value you can highlight that value on the charts.
SAVING THE PLOT
To save the plot as a PNG file, click on the small circle to the right of the legend, and select "save as PNG".
Open the expander under the 📊 Plot type drop down menu by clicking on the ➕ sign.
Additional options are available for selection.
By default all metrics present in the dataset are plotted. You can choose to plot only one metric, for instance "Amount".
Only the Amount plot will be plotted for all dimensions.
You can also change the order of the plot metrics. For instance instead of Amount, then Units, then COGS, you can choose a different order
The metrics will be plotted in the required order.
NUMBER OF ITEMS TO PLOT
By default, the four top items in terms of total Amount of the two periods are plotted, while the other items are aggregated together.
You can change the number of top items, and you can choose not to plot the value of the other aggregated items.
NORMALIZED AREA PLOT
Values can be plotted in absolute value, as a % of total dataset, as a % of total dataset after filters, or as a % of the result row. The last two options only make sense if you plot a result row.
If you choose any of the last three options (aka to plot as %) you get a normalized stacked area chart.
MOVE OR HIDE LABELS
Label placing might fail. For instance, the Action Figure, Splash Balls labels (as well as a few others) are not where they should be.
To correct this, you can download the file as a SVG and use any SVG editing tool to reposition the labels.
Alternatively, you can simply decide not to show any labels.
PLOT AS STREAMGRAPH
If "in absolute values" is selected in the "Plot values" widget, you will be prompted to choose between a standard area chart and a streamgraph.
Resampling data means aggregating time series by a new time period. For instance this chart has monthly values, one data point per month.
We could resample it bi-monthly to get one data point every two months.
After hitting Submit the chart is smoothed out.
CHOICE OF COLOR PALETTE
This elegant palette is both beautiful and functional.
This bright palette contains clusters with distinct color separations.
This fresh palette contains modern tones and stunning highlight colors.
BLUE & GREEN PALETTE
This contiguous palette creates a bi-chromatic chart in cool subdued hues.
KHAKI & DENIM PALETTE
This subdued palette great for complex charts.
This subdued palette is good for charts requiring contrast between segments.
HEATING UP PALETTE
This bright palette is great for complex charts.
POWERBI DEFAULT PALETTE
A lively, colorful palette.
This functional palette minimizes the risk of confusion between colors .