Hi there,
I am currently trying to produce the following data (below) into a scatter plot with an integrated one line graph as a trendline;
I want to show each of the opportunity's, seperated into individual quarters and there relevant month (ALL AS ONE COLUMN) as a scatter plot (with labels attached). However, as a separate series, I would like to produce a single trendline showing the accumulative revenue, e.g....For april a total of £10,000...with May being £22,000 (including both april and may). I cannot seem to produce a this graph, I have tried a pivot.
Please help!!!!
IMAGES ATTACHED TO SHOW GRAPH AND DATA
Capture.PNGCapture.PNG
Thank you!
Bookmarks