How To Easily Create Excel Charts

Charting data entered into an Excel spreadsheet does not have to be a complicated procedure. This article shows you step-by-step how to make that happen. First, we will create a simple worksheet and add some random data. Then we will create a quick chart of that data.

empty-worksheet

Open Excel to a blank worksheet.

add-data

Create some data to demonstrate with.

To enter today’s date, I used the shortcut Ctrl+;

random-values

One of the many available functions is RANDBETWEEN. We will use it to enter random values for our demo. Click on cell B4 and begin to enter the function by typing =ra. A list of functions starting with ra pops up. Select RANDBETWEEN.

random-between

Enter the range of values you want, low comma high, then press Enter.

drag-fill-handle

Now click on B4 and double-click the fill handle to copy the values down. Notice it generated additional random numbers.

auto-sum

After copying the formula down, we will add a total. Click in B8 and type Alt+= to generate the SUM function summing the numeric cells above it. Press Enter.

select-column

Click on the column heading B to select the entire column.

format-column-b

Right-align and choose comma style to format the values and line up the column heading.

select-data

Select the data to be included in the chart.

chart-created

Press F11 to have Excel generate a quick bar graph. Use the tools on the Design ribbon to change the type of graph, the colors, and more. Or just use it as is.

final-chart

The values are on the left of the chart and the area names are across the bottom with the bars above them.

Read More :   How to Turn Off iPhone 7 Mobile Data

In this demo, we learned how to auto-generate a date field, create random values, auto-sum a column of values, format an entire column of data, and generate a quick chart.

Dick

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to top button