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 the chosen dimension. For each dimension the value labels are shown for the first, last, highest and lowest values.
The integrated legends can also be positioned on the right....
or on the left of the plot...
SAVING THE PLOT
To save the plot as a PNG file, click on the small camera icon, and select "download as PNG".
Open the expander under the 📊 Plot type drop down menu by clicking on the ➕ sign.
Additional options are available for selection.
Use the menu to select the metrics and the dimensions you do not want to plot. The residual metrics and dimensions will be plotted.
Choose how many items you want to plot. The other items will be aggregated together.
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.
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.
EDIT AND MOVE LABELS
You can edit and move around plot titles and labels. In this chart..
...you can move the value labels around, delete them and adjust their position.
It is possible to annotate charts with lines, rectangles and circles. It is possible to modify the shapes and move them around, and delete them.
Hover and click on the "draw line", "draw circle" and "draw rectangle" icons on the menu bar on the upper right of the chart.
Draw and edit your shapes.
ADD PLOT MESSAGE
It is possible to add a message to the chart.
Add your message, one chart at a time, to the text box.
Once you have finished writing the message for a chart, click on the 🚀 Submit.
Your message will appear above the chart title.
The downloaded image of the chart contains the message.
The chart title is set on three lines: the first line contains the reporting unit ("who"), the second line the business metric ("what") and the third line the time period ("when").
You can adjust the position of the title, the message text and the horizontal line by moving them around with the mouse.
CHOICE OF COLOR PALETTE
This elegant palette is both beautiful and functional.
If you need to integrate 'Mparanza charts in a document prepared with Think-cell.
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 .
Avoids decorative use of colors. Similar pallets are available in other colors (greens, blues, reds,...)