Home / Tech / Excel Basics / 8.2. Working with the Excel Chart Ribbon

8.2. Working with the Excel Chart Ribbon

Now, I mentioned several lesson ago way back when we are talking about the Excel interface, we were talking about the ribbon the standard ribbon you got home Insert Page Layout and so on but the ribbon is very dynamic.

For example, if I select my charts just cooking some place empty down there, I have now got two new tabs at the top of my Screen, Design and Format and I think I double clicked on there so it gave me this format chart area and it, closed that we do not need that right now.

So just like in the chart. Two new tabs from the two new tabs, this is my chart tools ribbon.

I have got some design options that I can get into, I have got some formatting options. This is where you will find all the features that deal with your chart. Now I want to show off a couple of them here. Couple of the features. And we will talk about a few others as we continue through this discussion of charts.

Now first off, I have got a chart title and the range, All it says is chart title that is not very descriptive, This should say monthly budget. I am just going to click where it says chart title, I will go into there, highlight that text and I am just going to call this monthly budgets. Now the chart title was given to me by default the chart title itself is a chart option. It is something you could turn on and off and if with my chart selected I will go back to the Design tab, I do have some options to change the way my chart looks to change the way my title looks as well as other operations.

I can go to the little plus sign and site here I will find all sorts of elements of the chart, One of them is chart title.

Working with the Excel Chart Ribbon 1

Now something else you can do whether it is on the Layout tab or in the plus sign deals with the legend, I like the ledge and I want to keep it out there but I do not like it at the bottom, I want to put it at the top. Typically, when I read a chart it is kind of top to bottom, So I want to start at the top see the legend and then see the data. Something small but I just like the flow better this way. Then, in the plus side or the Layout tab will find the Legend, go a little arrow here and I am going to tell it to put it at the top.

Layout tab you will find something similar to the plus sign you will see chart elements with all the options chart titled, data chart and so on.

So, save little set up just found on the Layout tab rather than the plus sign.

Now something else you can do whether it is on the Layout tab or in the plus sign deals with the legend, I like the ledge and I want to keep it out there but I do not like it at the bottom, I want to put it at the top, Typically when I read a chart it is kind of top to bottom. So, I want to start at the top see the legend and then see the data. Something small but I just like the flow better this way.

So in the plus side or the Layout tab will find the legend, go a little arrow here and I am going to tell it to put it at the top, Now I have got my legend there at the top of my chart.

Working with the Excel Chart Ribbon 2

These are simple little changes whether it is your title or the legend or some other feature.

But we are trying to manipulate the chart to make it more accessible. It is a visual element and the quicker the users can glance at the chart and recognize the data and make those business intelligent decisions based on what we are presenting the better off we are going to be So think about how you want to leave or chart out what options do we want. There is a whole slew of stuff that you can mess around with here. I could spend an hour just talking about charts and all the features that are involved instead of a chart. But let us talk about just one more thing here and this is something that I want to point out more because I want to show you that you know what. Even though you have all these features you want to be careful about how much you add to the chart.

Once again, we do not want to make it too cluttered, We still want to make it accessible and readable.

Try it out. Poke around see what different options you have here. Try manipulate your chart, adding some of these chart elements.

About admin

Check Also

Excel Decimal Data Validation 1

15.2 Excel Decimal Data Validation

Create the little dropdown give the users the exact values for them to pick from. …

Leave a Reply

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