Microsoft Office Tutorials and References
In Depth Information
Net Income by Product in June
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.
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
Too much information in one chart