chart

When you create a chart, MS Excel will check the number of rows and columns. In a chart created automatically, by clicking F11, rows from the data table are created on the category axis. You may, however, sometime later decide that you would like to ... switch from rows to columns in the category axis. Fortunately, this is not difficult to accomplish. Follow the steps below to learn how: Select the chart. From the Chart menu, select Source Data. In Series in, select Columns. Told you it was easy! When you become a member at CarolsCornerOffice.com, you have access to this and many, many more ... (view more)

Microsoft Graph is a basic graphing program that is included with MS Word. It has the ability to view your graph data in both spreadsheet and graph formats. The graphs you create are capable of including gridlines if you wish. The grid lines make it ... visually easier to understand the data being presented in your chart. You are in control of how your chart grid lines are displayed. Follow the steps below: From the Chart menu, select Chart Options. Microsoft Graph will display the Chart Options dialog box. Make sure the Gridlines tab is selected. Use the check boxes to select which gridlines are ... (view more)

Sometimes when you are preparing a report you would like to add a chart to your document. The good news is that you can, and it is also very easy to do. Follow the steps below to create your chart in MS Word: On the Insert menu, click Object. Click ... the Create New tab. In the Object type box, click Microsoft Graph Chart. Click OK. To replace the sample data, follow these steps: Click a cell on the datasheet. Type the new text or numbers. If necessary, you can import data from a text file, a Lotus 1-2-3 file, or an MS Excel worksheet. You can also copy data from another program. To return to MS ... (view more)

When you want to show the data represented by your Excel chart, you can add a data table to the chart by selecting the Data Table tab in the Chart Options dialog box. You cannot though, use data tables with XY charts, pie charts, doughnut charts, ... radar charts, bubble charts, or surface charts. Data tables' formatting options are also limited compared to actual data cells. To overcome these limitations, you can include a picture of the actual data cells in your chart. Follow the steps below to insert a picture: Select the data range you want to include with your chart. Click to Edit | Copy. ... (view more)

Sometimes it seems as though Microsoft Excel is almost too efficient. For instance, Excel will automatically update a chart when you make a change to the chart data. If you need to capture a screenshot of your chart before a change is made, you need ... to break the link to its data source. Follow the steps below to prevent MS Excel from automatically updating your charts: To keep Excel from automatically updating a copy of a chart with new data, you need to break the link to the source data. Launch MS Excel if it isn't already open. Copy the chart that you do not want to be automatically updated ... (view more)

By default, the toolbars for Microsoft Graph appear on a single row. Click More Buttons to display additional buttons you can use to build and format your chart. You must change the sample chart and data to reflect your own figures. Each change you ... make in the datasheet will immediately appear on the sample chart. Click the datasheet and type your text and numbers. Press Tab or arrow keys to navigate from cell to cell. Add more rows or columns by typing them. Eliminate data by selecting and pressing Delete. Alternatively, you can keep the data in the datasheet but not include it in the chart ... (view more)

Brighten it up! You can adjust the color and spacing of your data markers to organize and codify your Excel charts. This explanation will show you how easily you can make the data easy on the eyes, too. When an Excel Chart Wizard charts a single ... data series in a bar or column chart, all data markers have the same default color. This can be hard to read, especially if there are a lot of points in the series. You could click on each data marker individually and change its color, or you could have Excel change them all for you. Follow these steps: Select the chart, then click on the data series ... (view more)

There may be times when you want to display a chart with your data using MS Excel, but you don't want it to take up the space on the worksheet. One solution is to place the chart in a document. First, create your chart and cut and paste it to a ... drawing program such as Paint. Save the chart as a picture file and then go back and insert a comment in the worksheet. To add the chart to the comment, follow these steps: Double-click the comment. Select the Colors and Lines tab. In the Fill section, select Fill Effects from the Color drop-down list. Select the Picture tab and then click the Select ... (view more)