Hi
Sean,
Yes, there is a way to show all values as positive in a bar graph, even if they are inherently negative. Here's how you can do it:
- Select the data range that you want to create a bar graph for.
- Click on the "Insert" tab in the ribbon at the top of the screen.
- Click on the "Bar" chart type in the "Charts" section.
- Choose the type of bar graph you want to create (e.g. clustered, stacked, etc.).
- Your bar graph will now be created with negative values showing as negative bars. To change this, right-click on one of the negative bars and select "Format Data Series" from the drop-down menu.
- In the "Format Data Series" pane that appears on the right-hand side of the screen, click on the "Fill & Line" tab.
- Under "Fill & Line", click on the "Fill" option.
- Select the "Solid fill" option and choose a color that you want to use for your bars.
- Under "Border", select the "Solid line" option and choose a color that you want to use for your border.
- Under "Effects", select the "Glow" option and choose a color that you want to use for your glow effect.
- Click on the "OK" button to apply your formatting changes.
- Your negative bars will now be displayed as positive bars with the color and effects that you chose.