Chart+Advisor

Sometimes, it is not easy to decide what kind of chart suits your information the best. The similarities between chart type purposes can often make choosing the correct type much more difficult. Excel 2007 has included a Chart Advisor to assist you in choosing the best one.

Simple Steps to Follow:

//1.) Highlight the cells and information you would like to include in your chart or graph. 2.) Go to the INSERT tab and choose Chart Advisor in the Office Labs group. 3.) Once the advisor analyzes the data, several options of charts and graphs will appear.//

===The chart options are ranked in percentages, according to compatibility. Regarding the information above, the chart that best fits the information given is a Clustered Column bar graph. ===


 * **After analyzing your data, the Chart Advisor provides several recommendations of charts to use.**
 * **Recommended charts are shown in a gallery.**
 * **You can hover over one or see all recommendations by expanding the gallery.**
 * **Charts are ranked by compatibility with your data, the first being the highest score chart.**
 * **You can clarify the information of the chart you have chosen by using the "Modify Chart" or "Filter Data" panels.**
 * **In the "Modify Chart" panel, you can remove any unwanted information and hit "Update Chart" to display a new chart that has removed the information.**
 * **Specific changes to plotted data can be made using the "Filter Data" panel.**
 * **When you are finished modifying your chart, you can insert it into the Excel spreadsheet by using the "Insert Chart" button.**