 Double-click it on the tab down below. I'm going to call it sales by item Data this will be my data tab because I'm going to put the actual graphs on another tab and then hide the data tab So I can print out all the reports without the data tab printing out and print them to a PDF form So that I can get them all on one PDF form Okay, so now that it's there. I'm going to hold control down and scroll up to zoom in to check out the data Let's see what it looks like So there we have it. Okay, so I'm going to go to the tab to the right and then back to the left I usually like to just see where the page screen ends right there and then I'm going to do my formatting Thing on this so these ones in here are formatted at Aerial 8 and these out here are formatted at Calibri 11. I'm going to make them all Calibri 11 by putting my cursor out here Go into the paintbrush and brushing the format on the entire sheet And then I'm going to start to delete the stuff that I don't need Well, let's let's first format the cells the way I'd like to see it I'm going to right-click on them format the cells And I'm going to make this currency bracketed numbers for negatives no dollar sign. Let's get rid of the decimals and Okay, so there we have that and then I'm going to get rid of what I don't need I'm going to put my cursor on row one. I don't need anything from here down to Down to let's go to here for now and right-click and delete and Then I don't need any of these other columns But I got to be careful on these columns that I don't remove any formulas. It looks like this is all hard-coded numbers I'm checking to see that it doesn't have a formula in it, but I just to make sure I'm going to select all of this data Right-click on it and copy it and Then I'm going to paste it right back down on top, but paste it One two three hard coding the numbers so everything is just hard-coded now no formulas And then I can be fairly confident getting rid of the quantity. I don't need that So I'm going to select column B right-click and delete it. I'm going to select this percent all this stuff Don't need any of that. I just want one set of numbers and a total right-click and delete Boom Okay, so there we have it now now we've got this added issue here where we've got this kind of sub-total Information and it still gave me this kind of double sub-total thing so You've got that, you know the design information up here And then you've got the fountains that has the sub-totals to get down to the to the total fountains down here So what I want is just to have the total fountains So I don't want any of this stuff up top So what I'm going to do is I'm going to have to delete from from row five to row eight and I'm just because this sums up if I add that that amount sums up Now notice this particular report had some funny formatting where it's still on the left So like if I double-click on these cells Then it it moves it over to the right to a normal formatting I don't know why sometimes the reports do that because they're not so I have to double-click on them and Have them move over so I can see The normal formatting for it So I'm just gonna do that all the way down So that it formats it Properly there probably is an easier way to to do that But I'll just do it this way for now. It's kind of an annoying little thing and then if I select These three this adds up to two six seven zero so I can I want to keep that total and delete from Here down to here. I'm just gonna delete that and Then I don't need the total so I'm gonna get rid of the total and Then the lights that looks good and then we've got the total design I don't need the total because this should add up to the five eight five three So I'm gonna get it gonna get rid of the total here Gonna get rid of that and I'm gonna get rid of the designs up top Delete that so I'm just getting rid of the subtotals and then down here We've got we've got these landscaping items That add up and then I've got this again this subtotal. I tried to get rid of but it still popped in here So we've got this and this Add up to that 198 right there So I don't need this subtotal from the sprinklers down to here I just want them just in the total sprinklers right click and delete double-click in here get rid of the total and So there is that and then we've got the total landscaping. I shouldn't need that because the sum of these 4407 should be that so I'm gonna get rid of the total and I'm gonna get rid of the landscaping and Then pest control I'm just gonna get rid of The these two because I just want the total right click and delete double-click on the total delete That stuff and then not specified. Okay, there it is. So then I'm gonna I'm gonna get rid of this total and Then just to see if I've messed anything up. I'm gonna sum it up now Just to double-check my number so it still comes out the 10 to 80 and I'm gonna delete. I'm gonna I'm gonna go back to QuickBooks here delete this Go back to QuickBooks and it should add up to the 10 to 80 so I didn't mess anything up So that's a little bit messy of a process Because you have those subtotals if I didn't have those subtotals then it would be you know a fairly easy easy process To deal with so it takes a little bit of cleaning up But now that I have this I should clean this up a little bit further by getting rid of these spaces because that could mess up the format of The chart which again is somewhat of a tedious process to do I'm there probably is an easier way to do this like I I could Well, I won't do it. I won't show you right now Just this isn't too bad with this many numbers. We'll just delete the spaces and then I'm gonna do that two more times Okay So now I can delete the added columns up top. I'm gonna or rows one and two Right-click delete. I don't need this total column because I'm gonna make a table out of it Right-click delete and so now we've got our raw data So so now I need to sort this data So I could do this by selecting the data go into the data tab adding filters But I like to add a table so I could put my cursor anywhere in the data I don't have to select the whole thing insert Table and then I'm gonna say okay. I'm gonna add a total column So it totals it up down below and so now I need to filter it from z to a drop down Z to a that's what that's we what we sold in terms of of the revenue So so now I can make a pie chart out of it Although there's too many slices most likely if I select the meat the stuff in the middle the data not the total in the headers insert pie chart There it is, but it's a little too too messy up here too many little slices So I'm gonna close this out. I'm gonna say maybe just down to like right there and then everything below I'm gonna put into other that adds up to 1178 So I'm gonna say this is 1178. I'm gonna call it other and then everything underneath from 8 To 15 right-click get rid of it get out and delete it. I'd still add up to 10 281 so it's a dollar difference because a rounding Then it was before but then I'm gonna select these and now I can insert A pie chart and it should be appropriate pie size And there we have it I can then change it. I've been choosing this one. I think something like that Well that one looks and I haven't been choosing that one, but I kind of like it. So there we have that