When you have data sets that you want to compare or see a trend over time, create a bar chart. In Google Sheets, you can create a bar chart and customize it however you want.
TIED TOGETHER: How to make a bar chart in Microsoft Excel
Create a bar chart in Google Sheets
Select the data for the chart by dragging the cursor through the range of cells. Then go to Insert in the menu and select “Chart”.
Google Sheets adds a standard chart to your table, which is usually a column chart. However, you can easily switch this to a bar chart.
When the graph is displayed, the graph editor sidebar should also be open. At the top, select the Setup tab and click the Chart Type drop-down box. Scroll down and select the bar graph.
The diagram is immediately updated to the new type and can be adjusted if necessary.
TIED TOGETHER: How to automatically generate charts in Google Sheets
Customize a bar chart in Google Sheets
The charts you make in Sheets have most of the same customization options. You can change the title, add axis titles, choose a background color, and choose the font style.
Open the Diagram Editor sidebar by clicking the three dots in the top right corner of the diagram and selecting “Edit Diagram”.
Select the Customize tab in the sidebar at the top. Then your customization options will be listed and minimized so you can expand the options you want.
Let’s look at a few options that you may want to change specifically for the bar graph.
TIED TOGETHER: The best fonts for Google Docs documents
Change the series
The chart uses default colors for each bar, but you can change these to match the colors of your business or organization.
Expand the Series section in the sidebar. Then click the Apply to All Series drop-down list and select the series you want to change.
You can then adjust the color and opacity for both the fill and the line. You can also choose a different line type and thickness.
Format a data point
If you want to highlight a specific bar on the chart, you can format it to make it stand out. Under the Line Options, in the Series section, click Add next to Format Data Point.
When the pop-up appears, either click the point on the graph or select it from the drop-down list. Click OK. “
A color palette is then displayed in the sidebar next to the data point. Select the color you want and the chart will update.
You can do the same procedure to format additional data points. To change or remove the data point, select a different one from the drop-down list or click on “Delete” in the sidebar below.
Add error bars
You can also add error bars to your chart based on value, percentage, or standard deviation. At the bottom of the Recurrence section in the sidebar, check the box next to Error Bars.
Then select Constant, Percent, or Standard Deviation from the drop-down list and enter the value you want to use on the right.
Your graph displays these error bars on the right side of the bars.
Creating a bar chart in Google Sheets is easy, and the customization options allow you to perfect the look of your chart. If you’re limited on space, check out how to use sparklines in Google Sheets instead.
This article was previously published on Source link