When I create in my charts you will recall my first steps, I selected the data I went to insert in my chart. Where did my chart show-up?
Yeah it showed up on the existing sheet the active sheet. So, I got my spreadsheet and the chart on one sheet. This is great because now I got that spreadsheet up above the actual data and the chart down below. And we can compare between the two easy and accessible, but by doing this my chart it might take up too much space and might cover something up there in two different spots, It is just maybe too much clutter in one spot.
What I would like to do is take the chart and put it on its own worksheet get a much larger charted out there where I can manage that chart all by itself.
This is a quick simple change, One little change move the chart to its own sheet.
So, I am going to slide my chart, That is the first step anytime you are ever going to manipulate the chart. Make sure you select the chart with it selected.
I will go to my Design tab top of my screen on the far right it is you got move charts, I will give that a click.
Now I have got a brand-new sheet their monthly budget chart and it is got the chart all by itself. A nice big chart where I can format it maybe make the numbers bigger and I can grab this. You know I can really start to maintain this chart all by itself. It is on it is own sheets, Nothing else to pump into and cover up. And now I got a much more real estate much more space inside of there to start to make things a little more separation and a little bit larger. So, try this out one simple little change. Select your chart, Go to the Design tab far right you will find Move chart in location and put it on its own sheet.
I am going to change it from an object in which is currently inside of my quarter one sheet to its new sheet its own sheet and I will give this a name. Try it out.