Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello.
I want to connect two or more points with a line in scatter chart.
Let say i have two stores and a warehouse which are the points and i want to connect the warehouse with the stores with a line from warehouse to stores the, line will show how many items has delivered to the store.
Has anyone an idea how can i do this with a scatter chart ?
Thank you in advance.
This property page is used collectively for scatter charts and grid charts. When a scatter chart has two field dimensions instead of one defined on the Dimensions page, each value in the first field dimension will result in one scatter data point for each of its associated values in the second one. These may then be connected by lines. The following display options are available in the Representation group:....
In the scatter chart a have the store and warehouse in a field store_id as dimension and in the expression i have the Latitude and the Longitude and i ask in the another expression to connect the warehouse and the stores with the line and according of the items that the warehouse has send to the store.
Can you explain how to do that in the scatter and the grid chart as you tell me above ?
Please, share sample....
Let's say that the warehouse is store 40
I send you also the excel file that i load the data from
I will try it tommorow