• Dp

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 dptutorials15@gmail.com


************************************************************


★ My Online Tutorials ► https://www.dptutorials.com


LEARNING RESOURCES I Recommend: https://www.dptutorials.com/resources


Subscribe for more Awesome Tutorials: http://goo.gl/NyAtg2


Support the Channel via shopping: http://ift.tt/2jH38PR


Tools that I use for Vlogging:

• Laptop: http://fkrt.it/AM9ab_uuuN

• Canon 200D Camera: http://fkrt.it/AMz75_uuuN

• Benro Tripod: http://fkrt.it/An1lm_uuuN

• Microphone: http://fkrt.it/A2RHz_uuuN

• Collar Microphone: http://fkrt.it/yL8kdQNNNN

• Screen recorder: https://techsmith.pxf.io/2BMjA

• Boom Arm Stand: http://fkrt.it/ypUD8QNNNN

• Zoom H1 Audio Recorder: http://fkrt.it/ypb7WQNNNN

• Harison Softbox Studio Lights: http://fkrt.it/ypCaRQNNNN

• Chroma Key Green Screen: http://fkrt.it/A3gnb_uuuN

• Background Support Stand: http://fkrt.it/A3cCb_uuuN

• Acoustic Foam Background: http://fkrt.it/ypsGdQNNNN

• USB RGB LED Strip: http://fkrt.it/A3T_5_uuuN

• Wireless Mouse: http://fkrt.it/A3Bqz_uuuN



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:

YouTube: www.youtube.com/c/dptutorials

G+: http://ift.tt/2kAOpa6

Twitter: https://twitter.com/dptutorials15

Facebook: http://ift.tt/2kfRnDi

BlogSpot: http://ift.tt/2kB14dh


Follow:

www.dptutorials.com

www.askplanner.blogspot.com


Support my blog, if you liked

  • YouTube Social  Icon
  • Facebook Social Icon
  • Twitter Social Icon
  • Google+ Social Icon
  • Blogger Social Icon