Microsoft Office Tutorials and References
In Depth Information
CREATING GRAPHICS
Net Income by Product in June
$2,500
$2,000
$1,500
$1,000
$500
$0
Scooters
Bicycles
Skates
Helmets
FIGURE F-9
Graph of net income by item sold
You should also avoid putting too much data in a single comparative chart. For example, assume that you
want to compare monthly mortgage payments for two loan amounts with different interest rates and time
frames. You have a spreadsheet that computes the payment data, as shown in Figure F-10.
FIGURE F-10
Calculation of monthly payment
In Excel, it is possible (but not advisable) to capture all of the information in a single clustered column
chart, as shown in Figure F-11.
Payments on $100,000 and $150,000 Loans
$1,400
$1,200
$1,000
$800
$600
$400
$200
$0
6.00%
6.10%
6.20%
Interest Rate
6.30%
6.40%
6.50%
$100,360 pmts
$100,180 pmts
$150,360 pmts
$150,180 pmts
FIGURE F-11
Too much information in one chart
 
Search JabSto ::




Custom Search