how to create pie chart in excel 2007 step by step

For example, if you had two houses and needed budgets for each, you could plot them on the same x-axis with a grouped bar chart, using different colors to represent each house. They can also shows trends over time, or reveal patterns in periodic sequences.īar charts can also represent more complex categories with stacked bar charts or grouped bar charts. For example, it’s easier to see which items are taking the largest chunk of your budget by glancing at the above chart rather than looking at a string of numbers. In the graph below, the values are percentages.Ī bar graph is useful for looking at a set of data and making comparisons. The horizontal (x) axis represents the categories The vertical (y) axis represents a value for those categories. Although the graphs can be plotted vertically (bars standing up) or horizontally (bars laying flat from left to right), the most usual type of bar graph is vertical.

The graph usually compares different categories. A bar chart is a graph with rectangular bars.

How to create pie chart in excel 2007 step by step