Graphing outside of Vend


Latest update: - -

This article will detail how to create graphs based on sales data outside of Vend, just like the widgets on the Dashboard. You can also use this tutorial to teach yourself how to pull any data out of Vend (not necessarily Sales data) to create different types of graphs. 

We will be using Microsoft Excel for Mac, but the steps should be similar for OpenOffice / Excel for Windows.

Firstly, we need to extract the data we would like. I'm going to make a sales totals by day graph.

So, navigate to Reporting > Sales Reports and run a sales report.

Then, we export the Sales Data that we are interested in.

 We then open this in Excel.

tut2.png

 Then we navigate to the line graph button in Charts:

tut3.png

Now create this, and go to select the appropriate data:

tut4.png

Your 'Chart data range' is the ' Sales incl. tax ' row and then the date headings are the ' Category (X) axis labels ':

tut6.png

 Lastly, We create the graph!

tut7.png

Note: You can, of course, format this graph further by playing around with the values and settings, then see how you go.

Powered by Zendesk