![]() Your final chart should now look like this: Now there is one problem with this solution. Then in the Format Code box, add a negative sign ‘-‘ and press the Add button. Then choose the Custom Category from the Number section. ![]() To do this, we need to create a custom number format for the vertical axis.įirst select your chart, then click on the Vertical Axis and press CTRL+1 to bring up the Format Axis dialog box. ![]() The only thing we need to fix is to make the vertical axis display a negative values instead of positive values. Repeat this step for the other negative data line. You can do this by selecting the chart and then selecting either one of the negative series and then press your delete key. So lets delete the values are are showing up as negative. To save time, it is sometimes easier to create a chart with too much data and then delete the data series that you don’t want. If you found the website and tutorials helpful, please consider donating to keep the lights on.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |