![]() ![]() The Change Chart Type dialog box will appear.We right-click on the series “% Reduction” and select Change Series Chart Typeįigure 5.We want to present %Reduction as a line graph. Vertical Bar Graph Change bar graph to line graph Two column charts or vertical bar charts will be created, one each for Quantity and %Reduction.įigure 4. Click Insert tab > Column button > Clustered Column. ![]() Next, we change the chart type of one graph into a line graph. There are two main steps in creating a bar and line graph in Excel. Final result: Bar and Line Graph Bar Chart with Line This article assists all levels of Excel users on how to create a bar and line chart. Excel allows us to combine different chart types in one chart. One helpful tip in improving dashboard presentation is by creating combination charts.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |