VideoPhoto

02 May, 2021

Creating graphs based on data table; the easy way

Whatever your Excel data source (entered or generated using a formula), convert the range of cells, they occupy, into Excel table. Simply select the range and use CTRL+T shortcut to do that. This way - when you later expand your data entries (add new data) or contract the table (remove some data) - your chart will get updated automatically (dynamically).

Here is kind of a template I've used to organize my data for charting:

 

I could fill the table with any function data, like in this example, or with raw data and get a graph based on just one function or two, or even three or four. Sometimes, when I've plotted e.g. two functions that have had different orders of magnitude, I used a secondary axis for one of them to display results in relevant scales.

To create your graph, select X column and appropriate Y column(s), then go to Insert tab and in Charts group select whatever chart type you need. That's it.

Now format your chart as you want to. Excel provides for that the whole plethora of options. Here I'm providing just two formatting examples to show you variety of possible solutions:



 

Enjoy Excel Charting!

 

No comments:

Post a Comment

All comments are held for moderation. I reserve the right to edit, censor, delete and - if necessary - block comments.