Hello everyone,
I am trying to create a graph with 2 axes that records number of visits on the left axis and money received on the right axis. I want the x axis to be dates (every date in each month for Jan-May..so 1/1/2007, 1/2/2007, etc). The graph is supposed to correlate whether the amount of visits affects the money received. It should also show how long after the visit was the money invested (hence the timeline type chart). I really have no idea how to go about this...I just started using Excel a couple weeks ago!
Thanks for any help!!
That isn't too tough. Just go to Insert > Chart and click on the "Custom Types" tab. Select "Lines on 2 Axes", and select your range and you can go from there.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks