That’s not the end of the program’s charting magic, though. You can, for example, change the chart or graph type at any point, as well as edit color schemes, the perspective (2D, 3D, and so on), swap axis, and much more.

The spreadsheet is the foundation of any business plan. It’s the place where you list all of your goals, track your progress, and make sure you’re on track.

Laying Out

Your Data

When charting data in Excel, it’s best to lay it out so that each row represents a record and each column contains elements of or pertaining to specific rows. This way, you can more easily see relationships between the data and see how it changes over time. ..

The spreadsheet has the following data: Name Age Gender Name Age Gender Name Age Gender Male 25 Female 21

The far-left column contains a list of laser printers. Except for Row 1, which holds the column labels, or headers, each row represents a specific printer, and each subsequent cell holds data about that particular machine.

Each column in the table below represents a different print speed metric. Column B shows how long it took to print the first page of a print job. Column C shows how long it took to print all pages, including the first page. Column D shows how long it took to churn the entire document, sans the first page out. ..

This spreadsheet is a basic one, but it’s easy to follow and helps streamline the data-collection process. You can map the cells in a small part of your spreadsheet or chart the entire document, or worksheet.

  1. The x-axis shows time, while the y-axis shows data.
  2. The first column is usually labeled “Date,” and the remaining columns are labeled according to the data in that column.
  3. To create a chart, you first select the data you want to include, and then use Excel’s charting tools to create it.
  4. Charts can be used for a variety of purposes, such as displaying information about trends or making comparisons between different groups of data. ..

Charting Your

Data

To start, select the worksheet you want to chart. Then, click on theChart button. This will open a new window that looks like this: In this window, you can select which columns and rows to chart. You can also map the entire worksheet by selecting all of the columns and rows in the left-hand column and then clicking on the Map button in the right-hand column.

  1. Select the range of cells that you want to chart, which in this case would be column B and C only.
  2. Use the Chart Wizard to create a new chart with just these two columns. ..

Select the data you want to chart, including the labels in the left column and headers in the columns you wish to include in your chart, as shown below.

  1. In the left column, select “Data Type.”
  2. In the first column, select “Date Range.”
  3. In the second column, select “Population.”
  4. In the third column, select “Income.”
  5. In the fourth column, select “Poverty Rate.”
  6. Click on Chart button at top of page to create your chart. ..

To view the entire spreadsheet, follow these steps:

  1. Open the spreadsheet in a text editor such as Microsoft Word or Google Docs.
  2. Click on the “File” tab and select “Print.”
  3. Click on the “Settings” button and select “Pages per Sheet.”
  4. Enter the number of pages you want to print in the “Page Size” box and click on the “OK” button.
  5. Select which columns you want to print by clicking on their headers and then clicking on the “Print” button.
  6. To save your work, click on the “File” tab and select “Save As.” ..

The data in the spreadsheet is as follows:

  1. Name
  2. Age
  3. Gender
  4. Race
  5. Religion
  6. Education
  7. Income
  8. Housing Status
  9. City of Birth
  10. State of Birth

If you want a more customized chart experience with Excel, there’s a lot of ways to get it. You can choose between different chart types, colors, and layouts; all of which are easy to achieve with the help of Excel.

Changing Chart

Type

There are several ways to modify your chart type in Excel. The easiest is to use the Chart Type drop-down menu. ..

On the Chart Design ribbon, choose Change Chart Type.

This opens the Change Chart Type dialog box, which allows you to change the type of chart that is displayed in the table.

There are many chart types, and clicking one of them displays several variations across the top of the dialog box. ..

To change the chart type in your Chart Design ribbon, follow these steps:

  1. Open the Chart Design ribbon.
  2. In the Chart Type group, click on the desired chart type.
  3. In the Style group, click on one of the pre-designed styles.
  4. To apply the style, click on OK.

Adding And Removing Chart Elements

The title of your chart is the name of the element that you want to add to your chart. The legend is a text description of the element. The X and Y axis are the values that you want to display on your chart.

The Chart Elements fly out when you click the paintbrush icon to the right of the chart.

The Chart Filters let you control the type of data shown in your chart, as well as the colors and borders. ..

If you want to change the look of your chart without having to go into the Format Chart Area, you can use the Chart Tools Options bar at the top of the worksheet. This bar has a variety of options that let you change everything from fills and backgrounds to gridlines, to 3D bars, pie slices, drop shadows – I can go on, and on. ..

When you create a chart or graph, make sure the font and color are consistent throughout the document.

When you have all the design tools at your disposal, it’s important to use them in a way that makes your graphics appealing and not so busy that they detract from the message you’re trying to convey.

When writing about business, it is important to keep things simple and to focus on the main points. This can be done by using only decorative fonts, and by avoiding complicated language. When discussing charts and graphs, it is important to focus on what the author is trying to say.

Charting tabular data can make it easier to understand and friendlier than column after column of text and numbers.