Uncategorized

Making a pie chart in excel 2008 mac

Then you have to look at the data through the eyes of your target audience. Ask yourself, are you giving them the most important facts? And are you speaking their language? This bad example of a sales chart is overwhelmed by too many fonts and text sizes, an overuse of graphics, distracting 3-D effects, poor color choices, and a cluttered background.

In general, bar charts are best for comparing amounts or showing trends over time. Use pie charts only when percentages equal percent. Then sketch something out on paper to ensure that your ideas, not the software, will guide your infographic. It may also be a good location for an important image you want viewers to notice before other elements.

As you might expect, the lower right-hand corner is a bad spot for must-see details. In this improved chart, the information is easier to understand. The sole font is sans serif. The bar colors are similar shades that get more intense as the temperature gets higher. For example, you could stick to three text sizes: the headline would be the largest; any introductory text, a little smaller; and the chart text, the smallest. Font Limit yourself to one or two type families to keep text easy to read.

Be sure to trash your photos after you select and email the final version to the conference. Notice it is 1. You can change the size of your picture in several ways, but crop it first.

Be sure the rectangle tool is highlighted. You can also adjust color on your own Image: Adjustment: levels. Once you are happy with the area and color save the image. The shape of each cropped image is important; similarly sized images will make a more attractive figure. Usually a resolution of about will bring a cropped image to a reasonable size kb. In a scientific paper composite figures provide pictorial information on the organisms studied, the methods and equipment used, and the results summarized in graphs.

For example, the figure above illustrates an experiment on photosynthesis performed in different plant species using a Qubit CO 2 gas analyzer. In lab you will take photomicrographs of leaves and organize them in a multi-panel figure. The example above is just one of the ways you can arrange the photographs.

A simple way to produce a figure with multiple panels is to use PowerPoint. The guidelines below outline the main steps. Note that you do not need to use Photoshop to change image size if you perform step 4 below. Save the drawings, photographs or graphs you wish to incorporate in your multi-panel figure on your desktop or in a folder. You can also paste pictures. You can specify image size in all versions of PowerPoint. In Microsoft PowerPoint for Mac, double click on the picture. You need to click on the arrows on the right of "Height" or "Width" see below to adjust the size.

A resized, smaller picture might disappear from view but will be found on the screen in the upper left corner. Drag it back on the slide. In PowerPoint for Mac, double click on the picture to display a window entitled "Format Picture" with "Size" in the left column menu. Edit picture. You can crop, flip images, change brightness and contrast, and add scale bars, arrows, and labels. Proceed in the same way with all the images you want to integrate in your composite figure.

If you line up several photographs in rows and columns it might be useful to select the same height and width for each of them.

How to Make 2D Excel Graphs Look 3D

You can also adjust the size of a picture by dragging its corner. Important : Be sure to present graphs large enough for all labels to be clear and legible. On a Mac you have the possibility to adjust the dots per inches dpi or the size of the composite picture by clicking on "Options Exit PowerPoint. Open the Word document with the text of your paper and insert your composite picture in the appropriate location.

Add a legend to your figure see "Results" in Science Writing Guidelines.

Understand the Information

In this example, there are two variables: Beetle Strain and of Adult Beetles. Thus, you will need two separate columns. To add a column, double click to the right of Column 1. This will create a second column. Repeat this step if more columns are needed. This will open a new window:. Repeat this process for column 2. Remember that in column 2 we are representing of adult beetles. What data type are these? Simply click on a cell and enter the appropriate values.

BISC /Statistics and Graphing - OpenWetWare

The completed table should resemble this:. The of adult beetles is considered to be the response or dependent variable since the number of adult beetles in a population depends on whether they are from Strain A or Strain B. You will see a small red triangle above the plot, which is the dropdown menu for many analysis options. See the Graphing Means in this file for details on graphing and how to incorporate figures into a scientific paper. This will be useful for graphing in Excel. Then you can copy and paste and edit in excel or word. Suppose you have a data set with more than two groups but you only want to compare two.

You can accomplish this by making a subset table using your large data set and performing a t-Test. To select a subset of your data: Suppose you wanted to compare Sunflower and Rhoeo in the light for this data set:. You may think that doing many t-tests to compare all possible pairs of means would be a good approach, but so doing would increase the risk of concluding a significant difference when none actually exists.

In the statistical lexicon, you would be committing a Type I error. This variable belongs on the X axis. In this case the categorical or nominal variable is the selected flour types. Set this as your X value.

Change the spacing in bar or column charts

Set this continuous variable as your Y value. This following screen will appear:. You will see the following print-out:. In some experimental or observational situations you may be investigating two or more factors that may be influencing results light and temperature, e. Two one-way ANOVAs that separately examine the two factors can also be conducted, but this approach is less efficient than the two-way approach, and also does not permit examination of a possible interaction between factors e.

For basic information on how Excel converts worksheet data into charts, refer to About Charting and Creating a Basic Chart. Both horizontal and vertical axes can be the Category axis. With the Category axis, you can change the interval of units between the tick marks. NOTE: If your category axis is denoted by words or phrases, the Automatic option will suffice in most cases. Double click the Category axis The Format Axis dialog box appears. In the Interval between tick marks text box, type the number of units you want between the tick marks of your chart's x-axis.

Both horizontal and vertical axes can be the Value axis.

With the Value axis, you can change the interval of units between the tick marks as well as set a maximum and minimum value for the axis. If your desired axis is the Category axis, refer to Changing the Interval of the Category Axis above. From the Categories list, select Scale. The Format Axis dialog box refreshes to display the Scale options. To change the minimum value of the y-axis, in the Minimum text box, type the minimum value you want the y-axis to display.

To change the maximum value of the y-axis, in the Maximum text box, type the maximum value you want the y-axis to display.

BISC 111/113:Statistics and Graphing

To change the number of units between the y-axis tick marks, in the Major unit text box, type the number of units you want between the y-axis tick marks. To change the number of units between the Major units , in the Minor unit text box, type the number of units you want between the Major units. From the Titles pull-down menu, select the desired axis. From the Click here to add title text box, type the desired axis title. You can alter chart axes in certain ways through the Layout command tab.

Depending what chart you are using, the Value and Category axes will be on either the x- or y-axes e. You can change the order of categories, add or remove axis labels and tick marks, or change the scaling of the Value axis. From the Categories list, select the desired option. A legend will help readers understand the graphical components of your chart. For example, in a bar chart, the legend tells your readers what each bar of a particular color or pattern represents. Without a legend, readers would see categories on one axis e.

HINT: Legends can be placed anywhere within the chart area, but are commonly located at the right of the chart. For pie charts, use data labels rather than a legend. Legend descriptions should be as concise as possible. Data labels display the exact measurements of the information used to create the chart beside the bars, columns, lines, and points that represent them. They can be especially useful if you have a wide or tall chart. However, on some charts, data labels may interfere with the chart's readability.