Till now we have learn that how we can create chart in MS Excel, but now we
will see that how we can add or hide any particular element from chart.
As we select our chart, our data is also selected by which chart is
In MS Excel 2016 there are different kind of chart options as compared to
previous Microsoft Excel versions like MS Excel 2007. Here on top right of
chart we are given three different icons which are of Plus sign, Brush
sign, and a Filter sign.
As soon as we click on Brush tool, we can see that there are different
types of chart options available which shows us different format of our
Now as we click on Plus sign, we can see on left side there is an pop up of
Chart elements. It contains different options like Axes, Axis Titles, Chart
Title, Data Labels, Data Table, Error bars, Gridlines, and Legends.
If we want any change in our axes, then we can double click on the data
displayed and then Format Axis dialogue box will get opened from right
side, which will give us different sizing options, color fill option etc...
Suppose we want to format any chart element then posting which we can do is
double click on that particular element and perform any option which we
So this is so we can format any element from the chart.
Line graphs, bar graphs and histograms, pie charts, and Cartesian graphs are arguably the four most popular. They are commonly used for, and are best for, a variety of purposes.
Chart patterns are divided into three categories by technical analysts: a classic chart pattern Patterns with a symbiotic relationship. Pattern of a candlestick.
Visual representations of spreadsheet data are charts and graphs. These images aid in the comprehension of worksheet data by highlighting patterns and trends that are difficult to spot in the data. Experimenting with the many charts in Excel is the greatest method to learn about them. Open a data-filled Excel spreadsheet.
MORI PARTH RAMESHBHAI
IT'S VERY GOOD AND USEFULL APLICATION WHERE WE CAN LEARN MANY COURSE AND MAKE CARRIER FREE OF COST . HOW CAN I APPRICIATE YOU I DON'T HAVE ANY WORDS REALLY IT'S VERY USEFUL FOR WHO CAN DO JOB LIKE ME
In this video they have mentioned like 2.1% increase in the salary how it can be above 1 lakhs , it should be 52000+2.1%+52000 which seems to be 53092 so, it's my feels as per the question they have
this is very help for excel study .thanks
I M VERY IMPRESSED SIR, THIS KNOWLEDGE IS VERY UISEFULL SIR
THANK YOU SO MUCH SIR
I'm very lucky because I have this app. I learned a lot from this app and will keep learning.
Thank you so much LearnVern.
best app for learning
This is very useful app by all courses in this app and thanks for learnvern