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?