![]() F2:F9 are the positive values, Click OK.ĥ. Back to the Select Data Source dialog, click Add to go to the Edit Series dialog again, select F1 as the series name, and F2:F9 as the series values. In the Series name textbox, choose the Percentage header, then in the Series values textbox, choose E2:E9 that contains increasing and decreasing percentages, click OK.Ĥ. In the Select Data Source dialog, click Add button to open the Edit Series dialog. Right click at the blank chart, in the context menu, choose Select Data.ģ. Select a blank cell, and click Insert > Insert Column or Bar Chart > Clustered Bar.Ģ. ![]() ![]() ![]() Now create the positive negative bar chart based on the data.ġ. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |