Where is chart options in excel 2010

In this case it is showing the current worksheet Good chart data example but you can click the dropdown to see a list of the worksheets in the current spreadsheet. Note that you cannot move it to a worksheet in another Excel workbook - this option simply isn't available. Move your Excel chart to a dedicated chart sheet: You can place your chart on a dedicated chart sheet if you wish.

This can be useful if you are printing your spreadsheet and want to include a full-page version of your chart within the printout. When you do this, Excel creates another tab at the bottom of your worksheet that sits alongside your other worksheet tabs. To move your chart to a dedicated chart tab, follow the instructions above for moving your chart to another worksheet, but choose the New Sheet option instead and, optionally, name your new chart sheet.

Quick Tip - Create a new chart on a dedicated chart sheet As a quick tip, you can create a new column chart in a chart sheet by selecting your data and pressing F11 on the keyboard. This automatically creates a column chart on a new chart sheet. You don't have to do anything else. You can then change the chart type and other options to suit your requirements.

Summary Moving or resizing a chart in Excel is a necessary skill to learn if you do anything with charts in Excel. Want to learn more? Try these lessons: How to create a bar or column chart in Excel. Select cells quickly and easily in Excel using the keyboard instead of the mouse. Our Comment Policy.

Notify me when new comments are posted. All comments. Replies to my comment. Related files optional. Enter the text and values in the appropriate cells.

Select the range of cells from A1 to D4. Select the Insert tab followed by the chart category you want. If you're not seeing the chart category you want, you can press the dialog launch button at he bottom right of the group to view more options. A new option with Excel a the Recommended Charts button. It will recommend some chart types according to your data.

Select All chart tab at the top of the window. Each chart categories offers many chart types. Excel has made it easier to combine many chart types into a signle chart with the Combo option. Before going any further, here is a description for some chart type that you may not have seen before.

There is also the stock charts that will show the highest, lowest and close values for a particular stock that you follow. The surface charts will show peaks and valleys from all the data.

The "Doughnut" charts looks a bit like a Pie chart. But someone ate the middle! This type of chart can represent many data series at the same time. Each "ring" is a data series. You can compare the proportion of each compared to the others. Also, the "Pie" charts shouldn't have more than five or six values to be readable. However, you can also regroup some values into a sub-chart. The « scatter » chart or the "X Y" charts are used to represent two values x and y for the same data point perceived value vs price point for example.

The Bubble chart is a evolved version of the scatter chart, or "X Y" chart, by adding a third dimension; the size of the point.

The X and Y coordinates determine the center of the point. The third value determines the size of that point. A Radar chart will allow you to compare many variables at the same time. That if why this type of chart must be read from it's center outward. The three charts above representents the same values.

Which one best represent the values? Would another chart type be more appropriate? The only person that can answer this question is you. Try out different types of charts before selecting the one that best suit your needs.

Remember, a chart is used to make it easier for the reader to interpret the data; not harder. Any item you place on your chart must meet that goal. For this example, select Column and 3-D column.

Press the OK button. With Office , Microsoft changed completly the menu structure; including the way to manage charts.

All the options are now under three tabs : Design, Layout and Format. Excel takes it one step further. The options that were under the layout tab have been moved to the right side of the chart.

Some other fun options were also added. The Design tab allows you to determine the chart type, the data source for these charts, the chart styles and its location in the workbook. The order of the options were changed in Excel But, most options are also available in Excel and Add chart element is new to Excel It replaces the options that were available under the Layout tab in Excel and These same options are also available by pressing the green plus sign that is to the right of your chart.

If you don't see it, just click inside your chart. The options will then appear to the right of the selected chart. Try to activate each option to see how it will change your chart. You may decide to keep some elements and remove others. Most of these elements offer more options. Even with these options, some elements can still be moved around your chart. Make sure that your presentation is clear so that people can understand quickly the reason for the chart. Excel offers you the option to select from a list of predetermied chart formatting styles.

It can make t easier for you to create your chart and to personalize it afterward. The change colors options offers you a quick way to change the colors of every data series. You can select from the list. You can always change a data series color with the options under the chart's Format tab. If you select headings with the data Excel will add the names to the chart automatically. Create the chart by clicking the Chart Wizard button on the standard toolbar.

The Chart Wizard starts at Step 1 by asking what type of chart to make see screen shot. Select a chart type and sub-type that works best for your data and click the Next button. At Step 2 of the Chart Wizard, observe if chart is displaying the data correctly. The only difference is that these chart types display cylinder, cone, and pyramid shapes instead of rectangles.

Exploded pie chart Displays the contribution of each value to a total while emphasizing individual values. Exploded pie charts can be displayed in 3-D format.

You can change the pie explosion setting for all slices and individual slices. However, you cannot move the slices of an exploded pie manually. Clustered bar chart Compares values across categories. Stacked bar chart Shows the relationship of individual items to the whole. They show and compare data the same manner. The only difference is that these chart types display cylinder, cone, and pyramid shapes instead of horizontal rectangles. Scatter chart with markers only Compares pairs of values.

A bubble chart is a kind of xy scatter chart, where the size of the bubble represents the value of a third variable. Bubble chart or bubble chart with 3-D effect Compares sets of three values instead of two.

High-low-close stock chart Illustrates stock prices. Open-high-low-close stock chart Requires four series of values in the correct order: open, high, low, and then close.

Volume-high-low-close stock chart Requires four series of values in the correct order: volume, high, low, and then close. Volume-open-high-low-close stock chart Requires five series of values in the correct order: volume, open, high, low, and then close. Like a pie chart, a doughnut chart shows the relationship of parts to a whole.

Doughnut chart Displays data in rings, where each ring represents a data series. Exploded doughnut chart Displays the contribution of each value to a total while emphasizing individual values. However, they can contain more than one data series. Create a chart with recommended charts. For a description of each chart type, select an option from the following drop-down list.

A column chart typically displays categories along the horizontal category axis and values along the vertical value axis, as shown in this chart: Types of column charts Clustered column and 3-D clustered column A clustered column chart shows values in 2-D columns. Use this chart when you have categories that represent: Ranges of values for example, item counts. Types of line charts Line and line with markers Shown with or without markers to indicate individual data values, line charts can show trends over time or evenly spaced categories, especially when you have many data points and the order in which they are presented is important.

Notes: Line charts work best when you have multiple data series in your chart—if you have only one data series, consider using a scatter chart instead. Consider using a pie chart when: You have only one data series. None of the values in your data are negative. Almost none of the values in your data are zero values. You have no more than seven categories, all of which represent parts of the whole pie. Types of pie charts Pie and 3-D pie Pie charts show the contribution of each value to a total in a 2-D or 3-D format.

Types of doughnut charts Doughnut Doughnut charts show data in rings, where each ring represents a data series. Consider using a bar chart when: The axis labels are long. The values that are shown are durations. Types of bar charts Clustered bar and 3-D clustered bar A clustered bar chart shows bars in 2-D format. Types of area charts Area and 3-D area Shown in 2-D or in 3-D format, area charts show the trend of values over time or other category data.

Consider using a scatter chart when: You want to change the scale of the horizontal axis. You want to make that axis a logarithmic scale. Values for horizontal axis are not evenly spaced. There are many data points on the horizontal axis. Types of scatter charts Scatter This chart shows data points without connecting lines to compare pairs of values.

Type of bubble charts Bubble or bubble with 3-D effect Both of these bubble charts compare sets of three values instead of two, showing bubbles in 2-D or 3-D format without using a depth axis. Types of stock charts High-low-close This stock chart uses three series of values in the following order: high, low, and then close.

Types of surface charts 3-D surface This chart shows a 3-D view of the data, which can be imagined as a rubber sheet stretched over a 3-D column chart. Type of radar charts Radar and radar with markers With or without markers for individual data points, radar charts show changes in values relative to a center point.

Type of histogram charts Histogram The histogram chart shows the distribution of your data grouped into frequency bins. Box and Whisker charts Office and newer versions only. Funnel charts show values across multiple stages in a process. Type of combo charts Clustered column — line and clustered column — line on secondary axis With or without a secondary axis, this chart combines a clustered column and line chart, showing some data series as columns and others as lines in the same chart.

Which version of Office are you using? Newer versions Office for Mac Column charts are useful to show how data changes over time or to show comparisons among items. Column charts have the following chart subtypes: Clustered column chart Compares values across categories.

Line charts have the following chart subtypes: Line chart with or without markers Shows trends over time or ordered categories, especially when there are many data points and the order in which they are presented is important. Pie charts have the following chart subtypes: Pie chart Displays the contribution of each value to a total in a 2-D or 3-D format. Data that is arranged in columns or rows on an Excel sheet can be plotted in a bar chart. Use bar charts to show comparisons among individual items.

Bar charts have the following chart subtypes: Clustered bar and 3-D Clustered bar chart Compares values across categories. Scatter charts have the following chart subtypes: Scatter chart Compares pairs of values.

Area charts have the following chart subtypes: Area chart Displays the trend of values over time or other category data. Stock charts have the following chart sub-types: High-Low-Close stock chart Illustrates stock prices.

A surface chart is useful when you want to find optimal combinations between two sets of data. Surface charts have the following chart subtypes: 3-D surface chart Shows trends in values across two dimensions in a continuous curve. Use radar charts to compare the aggregate values of several data series.

Radar charts have the following chart subtypes: Radar chart Displays changes in values in relation to a center point. There are no chart sub-types for treemap charts. There are no chart sub-types for sunburst charts. There are no chart sub-types for waterfall charts. Types of histogram charts Histogram The histogram chart shows the distribution of your data grouped into frequency bins. Bar charts have the following chart subtypes: Clustered bar chart Compares values across categories.

Scatter charts have the following chart subtypes: Scatter chart with markers only Compares pairs of values. Bubble charts have the following chart subtypes: Bubble chart or bubble chart with 3-D effect Compares sets of three values instead of two.

Stock charts have the following chart sub-types: High-low-close stock chart Illustrates stock prices. Doughnut charts have the following chart subtypes: Doughnut chart Displays data in rings, where each ring represents a data series. Need more help? Expand your skills.

Get new features first. Was this information helpful?