Now we will see it different types of charts in MS Excel. Till now we have
seen that how we can create chart and how we can format chart elements.
So first of all we will select our data, and then from INSERT tab we will
select 'Recommended Charts' option.
As soon as chart is inserted we can see two options in our chart tools
ribbon i.e. Design and Format. In Design we have an option 'Change chart
type', in which we have different types of chat options like Line chart,
Bar chart, Pie chart, Arial chart, and many other.
For now we will use clustered column chart, we also have more options like
'Switch row/column' which is used to switch row data to column data in our
Now we want to change the type of our chat then we can use 'change chart
type' button. We can choose any chat according to our requirement.
From different types of charts, we also have Pie chart, which always shows
us limited data in our chart, and also it is not effective for negative
So therefore we can change the type of chart according to our preference.
Formatting commands are used on a chart for the same reason they are used on a worksheet: to make the chart more readable. Formatting strategies, on the other hand, can help you qualify and explain the facts in a chart.
Manually change the formatting style of chart items.
To use the chart, simply click it.
Click the arrow in the Chart Elements box in the Current Selection group on the Format tab, and then click the chart element for which you wish to modify the formatting style.
By copying and pasting graph/chart formats into Excel, you can save time.
Right-click on the chart you want to copy the formatting from and choose copy (or pick it and use the Control + C keyboard shortcut).
To paste a special message, go to Home –> Clipboard –> Paste –> Paste Special.
Select Formats from the paste special dialogue box.
Click the OK button.
Shadow, Glow, Soft Edges, and 3-D Format are the four groups of options associated with this button. When you want to change the look of the text box that holds the select chart title, you can utilise the formatting choices associated with the Fill & Line and Effects buttons in the Title Options group.
Very good 👍👍
I learned a lot of formulas and functions through this lecture in free of cost. Thanks
Please give us an assignment or workbook to download and practice Excel after watching videos.
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