Formatting is a technique to enhance the looks of the charts by giving a cosmetic appearance to the chart title and chart legend. Titles are given to the X and Y axis to add clarity for the user. Formatting commands are applied to a chart for the identical reason they’re applied to a worksheet: they create the chart easier to read. However, formatting techniques also facilitate chart quality and explain the data in a chart.
Dataset Used
A Stacked Column Chart is drawn using the sample excel sheet below. Below is the dataset mentioned and the link to the dataset is here.
The stacked column chart can be drawn for the dataset given above, in order to obtain the chart, you simply require to select the type of chart (stacked column chart in this case) you want, and then you may start customizing/formatting the chart.
Format Stacked Column Chart
Below are the steps that can be followed in order to format a stacked column chart in power BI,
Step 1: Click on the format icon under Visualization to format the chart.
Step 2: To format the x-axis ‘values’ click on the drop-down of the X-axis.
The following results are obtained due to the modifications done:
- Fonts are changed to ‘Cambria’
- Font size is set to ’12’
- Fonts set to ‘Bold’
- Color set to ‘Black’
Step 3: To Format the x-axis ‘Title’ click on the drop-down of the X-axis.
The following results are obtained due to the modifications done:
- Title set to ‘Countries’
- Fonts are changed to ‘Verdana’
- Font sizes are set to ’15’
- Fonts set to ‘Bold’
- Color set to ‘Black’
Step 4: To Format the y-axis ‘Value’ click on the drop-down of the Y-axis.
The following results are obtained due to the modifications done:
- Fonts are changed to ‘Cambria’
- Font size is set to ’12’
- Fonts set to ‘Bold’
- Color set to ‘Black’
- Switch axis position ‘ON’
Step 5: To Format the y-axis ‘Title’ click on the drop-down of the y-axis.
The following results are obtained due to the modifications done:
- Title set to ‘Product Count’
- Fonts are changed to ‘Verdana’
- Font sizes are set to ’15’
- Fonts set to ‘Bold’
- Color set to ‘Black’
Step 6: To change the Legend of the Column chart.
The following results are obtained due to the modifications done:
- The position changed to ‘Center left’
- Fonts changed to ‘Segoe UI Bold’
- Fonts size to ’13’
- Color to ‘Black’
Step 7: To add gridlines on the Chart, click on the dropdown Gridlines under Visuals.
The following results are obtained due to the modifications done:
- Style Changed to ‘Solid’
- The Color Changed to ‘Black’
- Width Changed to ‘2’
Step 8: To get Slider on Values ‘ON’ Zoom Slider.
The following results are obtained due to the modifications done:
- Slider on y-axis ‘on’
- Slider labels are ‘on’
- Green Arrow shows the Position for sliding the Bars
Step 9: To change the Column Color or stack click on the column bar under the visualization.
The following results are obtained due to the modifications done:
- The reverse Stack is ‘ON’
- No colors are changed
Step 10: To change the Space between the columns click on Spacing.
The following results are obtained due to the modifications done:
- Inner Padding Changed to ’36px’
- Minimum width to ’20px’
Step 11: To Show, the Values of each type on bars click on Data Labels.
The following results are obtained due to the modifications done:
- Series are applied to ‘All’
- the position is set to ‘Inside Center’
- Orientation to ‘Horizontal’
Step 12: To change the font and color of the data label click on ‘Values’.
The following results are obtained due to the modifications done:
- Fonts changed to ‘Segoe UI’
- Font size changed to ’11’
- The color changed to ‘Grey’
- Decimal Place to ‘1’
- Background Transparency ’76’
Step 13: To show totals of Each Column ‘on’ Total Labels.
The following results are obtained due to the modifications done:
- Font Changed to ‘Seogoe UI Bold’
- Font Size to ’11’
- Font Style ‘Italic’
- Color to ‘Black’
- Value decimal Places ‘1’
Step 14: To Format Table Position, Table Table Title, and Table Effect Click on ‘General’ under visualization.
Step 15: To manage the Size and Position of the table Click on the drop-down of Properties.
The following results are obtained due to the modifications done:
- Height set to ‘680’
- Width set to ‘981’
- Horizontal position to ‘299’
- Vertical Position to ’34’
Step 16: To change the Title of the Table click on the drop-down of the Title.
The following results are obtained due to the modifications done:
- Title Changed to ‘Product Count vs Country’
- Heading to ‘Heading2’
- Font to ‘Constantia’
- Font Size to ’22’
- Font Style to ‘Bold’
- Text Color to ‘Light Blue
- Text Background to ‘Black’
- Text Alignment to ‘Center’
Step 17: To give color effect to the chart click to affect under General.
The following results are obtained due to the modifications done:
- Background color changed
- Transparency changed to ‘28%’
- Visual border of color ‘Blue’
- Rounded corners ’30px’
- Shadows Color changed to ‘Black’
- Offset changed to ‘Inside’
- Position Changed to ‘Left’
Step 18: To change the color of the Icon on the Top click on the Header Icon.
The following results are obtained due to the modifications done:
- Background Color to ‘Yellow’
- Border to ‘Black’
- Icon to ‘Black’
- Transparency to ‘0%’
These are a number of the most frequent formatting done on Stacked Column Charts. Power BI provides us with dynamic options to format a chart and it is often explored with some self-research easily.