All about the Graph, no Pivot

graphimage

I’ve had several requests on “what is the fastest and easiest way to create graphs in Excel without using Pivot Tables or Pivot Charts?”

Well, the answer is quite simple.  Have a look at the quick tutorial below.  We will be creating a graph that represents the number of employee terminations for a given year.

Firstly, create a summary table in a new worksheet that looks similar to the one below: (you can use any type of information relevant to what you do, sales per month, widgets built per month, anything that works for you).

Now, let’s add some data.  If there is no information available for a specific month you simply leave it blank, or add “0”, whichever works for you.

Now select the Table data starting in the top left cell – “Terminations” (remember, in order to select data, left click on the cell where you want to start your selection and hold in the left mouse button whilst you drag the cursor to the last cell in the range that you wish to select).

Once you’ve selected the data, head over to the ribbon at the top of your screen, click on “Insert” and select the relevant Graph that you would like to use.

Once you’ve clicked on the relevant Graph that you want to be displayed, you should see something similar to the Graph below:

And now all we have to do is make a few final tweaks and were done. 🙂

Stay tuned for more articles on how to add Axis Titles, Data Labels, Chart Titles, Pivot Charts, Slicers and Special effects.

Until next time.

Leave a Reply

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