Skip to content Skip to sidebar Skip to footer
Home / Pie

Excel Two Pie Charts Next To Each Other

Two Pie Charts Next To Each Other

Introduction

Excel is a powerful tool that can be used in many ways to manage data, create charts and graphs, and perform complex analysis. One of the most common types of charts used in Excel is the pie chart, which can be used to display data in a visually appealing way. In this article, we will explore how to create two pie charts next to each other in Excel.

Step-by-Step Guide

Follow these steps to create two pie charts next to each other in Excel:

  1. Open Excel and create a new workbook.
  2. Enter your data into the worksheet. Make sure that the data you want to display in the pie charts is in separate columns.
  3. Select the data you want to use for the first pie chart.
  4. Click on the Insert tab in the ribbon at the top of the screen.
  5. Select the Pie chart icon in the Charts group.
  6. Select the type of pie chart you want to use. You can choose from 2D, 3D, or Doughnut pie charts.
  7. A chart will be inserted into the worksheet. Click on the chart to select it.
  8. Right-click on the chart and select Copy from the context menu.
  9. Select the cell where you want to place the second pie chart.
  10. Right-click on the cell and select Paste from the context menu.
  11. The second pie chart will be inserted into the worksheet.
  12. Click on the second pie chart to select it.
  13. Right-click on the chart and select Format Chart Area from the context menu.
  14. In the Format Chart Area pane, select the Properties tab.
  15. Under Layout, select the checkbox for "Move but don't size with cells".
  16. Under Size & Properties, change the Height to match the height of the first pie chart.
  17. Click on the first pie chart to select it.
  18. Right-click on the chart and select Format Chart Area from the context menu.
  19. In the Format Chart Area pane, select the Properties tab.
  20. Under Layout, select the checkbox for "Move but don't size with cells".
  21. Under Size & Properties, change the Width to half of the worksheet width.
  22. Click on the second pie chart to select it.
  23. Right-click on the chart and select Format Chart Area from the context menu.
  24. In the Format Chart Area pane, select the Properties tab.
  25. Under Layout, select the checkbox for "Move but don't size with cells".
  26. Under Size & Properties, change the Width to half of the worksheet width.
  27. Your two pie charts should now be displayed next to each other.

Tips and Tricks

Here are some tips and tricks to help you create two pie charts next to each other in Excel:

  • If your data is not in separate columns, you can use the "Text to Columns" feature to split it into separate columns.
  • You can format your pie charts to make them more visually appealing by changing colors, fonts, and other settings.
  • If you have more than two pie charts to display, you can repeat the process to add additional charts to the worksheet.
  • If you want to change the size or position of the pie charts, you can use the Format Chart Area pane to make adjustments.

Conclusion

Creating two pie charts next to each other in Excel is a simple process that can help you display your data in an organized and visually appealing way. By following the step-by-step guide and using the tips and tricks provided, you can create professional-looking charts that will impress your colleagues and clients.

Related video of Excel Two Pie Charts Next To Each Other

You may like these posts :