3
I intend to plot y=cos(cX)
in Excel, where c
is a constant produced in first cell of column C using RANDBETWEEN(-50,50)
. Column 'A' represents X
values (from -100 to 123) and column B contains f(x)
values generated using the function f(x)=cos(cX)
.
Then I select columns A and B and hit insert chart (2D line chart), which gives the following plot:
This is not What I wanted. I want X values to be plotted on horizontal axis and Y values to be plotted on the vertical axis. Here, it is inverse. How can I make it show the way I want?
1Your problem is using the wrong type of chart. The X axis shows the serial number of the "category", your first data column is the blue line, and the second data column is the line hovering around zero. Change the chart type to scatter chart. – fixer1234 – 2015-07-05T22:26:06.507