Editing a hierarchy chart in Excel can be a crucial task, especially when you need to present complex data in a clear and understandable format. Microsoft Excel provides a range of tools to help you create and edit these charts seamlessly. Let's dive into a step-by-step guide on how to edit a hierarchy chart in Excel.
The first step is to differentiate between an organization chart and a hierarchy chart. While both help to illustrate hierarchical data, an organization chart typically shows the structure of a business or organizational unit, and a hierarchy chart shows the relationships between items based on their hierarchical levels. Now, let's start editing your hierarchy chart.
Select and Customize the Chart
Every editing process begins with selection. To edit your hierarchy chart, first, you need to select the chart. This can be done by simply clicking on the chart. Once the chart is selected, you will have a set of tools at your disposal, mainly located under the 'Design' and 'Format' sections in the 'Chart Tools' tab.
Under 'Design', you can change the chart type, add or switch row or column, and add or remove chart elements. The 'Format' section offers options to format the chart elements, axis, and plot area.
Change the Chart Type
If you're not satisfied with the chart type, you can change it under the 'Change Chart Type' option. Excel offers a variety of chart types, such as bar, line, pie, and more, helping you to best present your data.
For instance, if your hierarchical data is better represented as a list, you might want to change your chart type to a simple list or table. Just click on 'Change Chart Type', select the desired chart type from the list, and click 'OK'.
Add or Remove Rows or Columns
Hierarchy charts are based on hierarchy, so it's crucial to keep the right number of rows or columns. You can add or remove rows or columns depending on your needs. To add a new row, right-click anywhere on the chart and click on 'Select Data'. In the 'Edit Series' box, click 'Add', provide the necessary details like series name, series formula, and click 'OK'. Repeat the same process to remove any unwanted rows or columns.
Remember, the order of series in the 'Select Data' source list determines the order of hierarchy in the chart. Hence, rearrange them accordingly.
Format the Chart
Once you've made the necessary adjustments to your chart type, it's time to adjust the visual aspects. The 'Format Selection' pane in the 'Format' section allows you to customize various elements of the chart, such as color, line, fill, and text.
For instance, you can change the color of a data series to differentiate between different levels in the hierarchy. Just click on the series, go to the 'Format Selection' pane, and select the 'Fill' icon. From the color options, select the color you desire.
Format the Axis
You can also customize the axis. Once you've selected the axis, the 'Format Selection' pane will have various options related to the selected axis. For example, the 'Axis Options' group allows you to reverse the plot order, swap series, or even add gridlines.
You can also add titles to the axes to better illustrate your data. To do this, select the axis, go to the 'Format Selection' pane, and click on the 'Text' icon. Add your title in the 'Has Text' box, and click 'Close'.
Format the Plot Area
The plot area is the area where your data series is plotted. You can customize the plot area by changing its fill, line color, and line style. Select the plot area, go to the 'Format Selection' pane, and select either the 'Fill' or 'Line' icon to make the necessary changes.
Keep in mind, changes to the plot area affect the entire chart. If you want to apply specific changes to certain parts of the chart, consider splitting the chart. This can be done under the 'Switch Column' option in the 'Design' section.
That's it! Hopefully, these steps have helped you edit your hierarchy chart in Excel. The key to successful editing is understanding what you want to convey and using Excel's tools to effectively express that. As you work with Excel more, you'll become increasingly comfortable creating and editing charts to effectively communicate your data.