This weekend, let us talk … umm… charts. I want to know if you absolutely make sure your charts look good everytime you sent them out to someone. I do this most of the time.
My usual chart sex up routine is,
- Remove the background
- Add labels and remove grid lines and legend
- Highlight necessary data and set some dull color to the rest (if needed)
- Change fonts, most often change them to Verdana
- Format axis and axis labels
Of course, I don’t do this every time. Instead I use some user defined charts and save tons of time.
How do you sex up your charts? or you say “not tonight honey” to them.
Learn 2 more charting principles in naughty but totally fun way: Is your chart’s underwear showing? | Are you making blow charts?
One Response to “How to compare two Excel sheets using VLOOKUP? [FREE Template]”
Maybe I missed it, but this method doesn't include data from James that isn't contained in Sara's data.
I added a new sheet, and named the ranges for Sara and James.
Maybe something like:
B2: =SORT(UNIQUE(VSTACK(SaraCust, JamesCust)))
C2: =XLOOKUP(B2#,SaraCust,SaraPaid,"Missing")
D2: =XLOOKUP(B2#,JamesCust, JamesPaid,"Missing")
E2: =IF(ISERROR(C2#+D2#),"Missing",IF(C2#=D2#,"Yes","No"))
Then we can still do similar conditional formatting. But this will pull in data missing from Sara's sheet as well.