If you have for some reason chosen an inappropriate type of chart, you can easily change it. First select the chart and go under Chart Tools and Design tab. From there the very first button on the ribbon is called “Change Chart Type”. Click on it once and you’ll be able to try again with hopefully a more suitable chart type for you.
Continue readingTag Archives: chart
How to display a contribution of each value to a total on a chart? | Excel 2007
Best used for contribution display is a pie chart. Select your table only including the cells you wish to be presented on the chart and go under Insert tab into Charts section. Under “Pie” choose the type of the pie chart that suits you best. Unfortunately no live preview is applicable in this case.
Continue readingHow to add to chart elements their actual values? | Excel 2007
Click on the chart and go under Chart Tools and Layout tab. In Labels section click on “Data Labels” and from the appearing menu choose whether you wish for the labels to show up or not. Depending on the chart type you can also determine the placement of those labels.
Continue readingHow to change chart date format in x axis? | Powerpoint 2007
Press with your right mouse button on the chart and choose “Format Axis”. Choose “Number” in the left menu. If the category is date then you can choose a new type or enter your custom in format code field.
Continue readingHow to add a data table to a chart? | Excel 2007
Click on the chart and go under Chart Tools and Layout tab. In Labels section click on “Data Table” and from the appearing menu choose whether you wish for the table to show up in the first place or whether the table should include the legend keys as well. The last option is handy in case you wish to remove the legend from the chart.
Continue readingHow to add, remove or reposition chart legend? | Excel 2007
Click on the chart and go under Chart Tools and Layout tab. In Labels section click on “Legend” and from the appearing menu choose whether you wish for the legend to show in the first place, or the placement of it if you decide to show it on the graph.
Continue readingHow to add a title to the chart? | Excel 2007
Click on the chart and go under Chart Tools and Layout tab. In Labels section click on “Chart Title” and from the appearing menu choose the placement of the title. Notice that you can also remove the title under this menu.
Continue reading