Question

About Excel,

I have this data but how can I change the origin so 0,0 is not on the outside corner like it is in the right-side picture and make it inside the graph area like the left-side picture?

Tue Jun 4 23:25:17 Q E Word File Tools Table Window Help 100 % E. Edit View Insert Format thesis,pdf (page 22 of 29) thasis.pdf hue lig -Saved to my Mac summary of. Search in Document AutoSa 150 Home Insert Draw Design Layout References Mailings Review View Share 20 A A Calibri (Bo.. A 12 Aa Paste B U A Styles Ser X A L 100 100 50 0 50 50 100 4.3 Philips English (United States) Focus Page 1 of words standard deviation traffic volum 50 Standard Deviatio

Answer 1

This type of graph is not feasible in Excel, but it can be designed in R. This graphs is manually plotted. After plotting the graph, we can design its axis as per our requirement manually. Excel does not support this type of mechanism, therefore I request you to kindly make it as below graph. I did this by using the snipping tool. Just pic the graph only without its axis and then pic another with axis then adjust as per your requirement.

feel free to ask any more help if you need.

100 0 100 Standard Deviatio 50