It’s relatively easy as well as Excel Graph Wizard will walk you within most of it. Develop a sheet with 4 columns named: Published Date, Amount, Date, in addition to Views. You will need to fill inside data to be charted. Make use of minimum of Five and more (preferably the latest DOZEN articles as your info. Make sure you begin the chart/graph with cell “A1″ which represents up left cell.
Highlight info to be graphed, but don’t highlight the headings Post Day, Volume, Date, Number of views. When selected, click Insert – Menus and select Chart. Then select Graph Enter.
After selecting chart types you’re now ready to see the Chart Wizard to actually finish the chart. You’ll be asked to title your X together with Y-axis and in case this really is complicated just add a name inside and when you add you can view where it would appear from your wizard.
You should embed the graph into your sheet or produce an additional sheet. Click finish and the chart right now shows up as component in the spreadsheet. Now could be in a position to actually see the development as well as ebb along with flow on your reports in excel.