Hey guys... I have uploaded a workbook with a data table and an image of a scatter graph which I am trying to reproduce but to no avail!
Any ideas? Many thanks
Hey guys... I have uploaded a workbook with a data table and an image of a scatter graph which I am trying to reproduce but to no avail!
Any ideas? Many thanks
Last edited by Blake 7; 10-29-2014 at 07:49 AM.
Blake 7
If your question has been answered, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
If any member's response has helped to solve your problem, please consider using the scales icon on the top right of their post to show your appreciation.
http://failblog.org/
You need to set up an intermediate table where you have appropriate pairs of x and y values. I've linked these to the original data in columns R to Y of the attached file so that they will reflect any changes, but you could just copy/paste if the data is static. Then you use the intermediate table as the source for the graph.
Hope this helps.
Pete
Hey Pete - hope you are well.
Ahhhh, I see now! I would never have guessed that... well, not for a while! thats a great lesson! many many thanks!
You're welcome, and thanks for the feedback.
Good to "talk" to you again.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks