How to make a bar graph in Excel with 3 variables
You can watch a video tutorial here.
Graphs are great ways to visualize data and Excel has several tools for creating and formatting charts. The type of chart that you create depends on the dataset that you have. Using the charting tools in Excel, you can explore various types of charts and decide on the one that best suits the data that you are visualizing. When you need to create a bar graph with 3 variables, you need to decide which variable is displayed on the x-axis and which will come on the y-axis.
Step 1 – Open the Insert Chart box
– Select the data on which the graph is to be prepared
– Go to Insert > Charts
– Click the Recommended Charts option
Step 2 – Choose the chart
– Go to All Charts > Bar
– Select the chart that shows the following:
>‘Year’ on the y-axis has the year
>‘Profit’ and ‘Sales’ on the x-axis
– Click OK
Step 3 – Check the result
– The graph is created on three variables:
>Y-axis has the year
>X-axis has the Profit and Sales
Step 4 – Design and Format the chart
– Change the title of the chart by clicking on the default title and editing it
– Select the chart to summon the Chart Design and Format menus
– Add more elements to the chart such as the axis titles, data labels, etc. using the Chart Design menu
– Format the chart with the options on the Format menu