top of page
  • Writer's pictureDp

How To Display Multi Categories In Excel Charts

Hello Friends welcome to dptutorials

Do You Know that we can show the multi categories in an excel chart?? like shown here...

Let's see this trick in detail in this tutorial.

1. Let's consider an example of my grocery list and expenditure spent on those items, like shown here.

2. Using this data, let's create a chart showing the expenses by category wise.

3. Just arrange the data as shown here. And add the category name in the column left to the items list.

4. I categorize these as Fruits for the first 3 items, and then dairy as next category for next three items, and then meat for the next 3 items. So I am dividing these into 3 broad categories fruits, dairy and meat.

5. Now, Select the entire data set.

6. Go to Home tab, Click Insert, under charts, select 2D column chart. This one.

7. You will get a chart. Format it the way you want.

8. That's all friends, you can see the categories in the chart axis, as per your wish.

Watch this video tutorial for better understanding:

If you liked this tutorial, share it with your friends. And also you can follow us on Youtube, Twitter and Facebook. We would love to hear from you, Please do comment, suggest or compliment our work and we shall make it better for you. You can write us at


★ My Online Tutorials ►


Subscribe for more Awesome Tutorials:

Support the Channel via shopping:

Tools that I use for Vlogging:

• Laptop:

• Canon 200D Camera:

• Benro Tripod:

• Microphone:

• Collar Microphone:

• Screen recorder:

• Boom Arm Stand:

• Zoom H1 Audio Recorder:

• Harison Softbox Studio Lights:

• Chroma Key Green Screen:

• Background Support Stand:

• Acoustic Foam Background:

• USB RGB LED Strip:

• Wireless Mouse:

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!


You Can Connect with Me at:








Recent Posts

See All


bottom of page