Slider

How to Create an Inverted Histogram in Microsoft Excel

Date:2020-3-22 Author:Olivia

We have shared the method to make a histogram in Excel in previous post, but sometimes you might need to personalize it for special display purpose. Just follow these steps and let’s see how to create an inverted histogram in Microsoft Excel.

1. You got an original histogram in Excel worksheet, and here I take Monthly Sales in 2018 as an example (all data is fictitious).

How to Create an Inverted Histogram in Microsoft Excel

2. Right click the y-axis of your histogram, next hit Format Axis in the pop-up list.

How to Create an Inverted Histogram in Microsoft Excel

3. When Format Axis dialog box appears on the left, go to histogram icon tab and check the box of Values in reverse order.

How to Create an Inverted Histogram in Microsoft Excel

4. Now the original histogram has been inverted as below.

How to Create an Inverted Histogram in Microsoft Excel

5. Select the second button on the right, you can also modify Style and Color of the histogram, here I’d like to show you some examples.

How to Create an Inverted Histogram in Microsoft Excel

6. In the options of Style, you can select one to insert background color of the histogram.

How to Create an Inverted Histogram in Microsoft Excel

7. In the options of Color, you can select one to make the histogram more artistic.

How to Create an Inverted Histogram in Microsoft Excel

8. With different combinations, you can make the histogram to achieve the best display effect according to actual needs.

If you find our content useful, donations are always welcom. we'll keep going and hold more giveaways in the future.

Windows 10: Run Troubleshooter to Fix Network Connection Problems
Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

2 thoughts on “How to Create an Inverted Histogram in Microsoft Excel”

  1. vurtil opmer says:

    hello!,I love your writing so a lot! share we keep up a correspondence extra approximately your article on AOL? I need a specialist in this house to unravel my problem. Maybe that is you! Having a look ahead to peer you.

    1. Olivia says:

      Hi, thanks for your appreciation and what do you mean by mentioning AOL(American On Line)? Do you want to reprint our articles on this website?

Leave a Reply

Your email address will not be published. Required fields are marked *