# Graphfic type on Excel

1. ## Graphfic type on Excel

http://img30.imageshack.us/img30/5508/semttulopv.jpg

I've been trying for some time to reproduce this type of graphic on Excel with no success. The only thing I know is that is a scatter plot, but that trendline and the %error lines are beyond my understanding. Would someone please show me how can I do it...

Regards.

2. ## Re: Graphfic type on Excel

You'll need aditional columns for each line:

Book1.xlsx

3. ## Re: Graphfic type on Excel

Originally Posted by zbor
You'll need aditional columns for each line:

Attachment 52908
Thank you, that's a good idea. But if you notice the graphic I showed up there, the trendline and the "error lines" are well fit to the graphic.

4. ## Re: Graphfic type on Excel

You didn't post any data, you posted a picture. Zbor used random data and showed a trendline and the two additional (+/-25%) lines.

5. ## Re: Graphfic type on Excel

Originally Posted by shg
You didn't post any data, you posted a picture. Zbor used random data and showed a trendline and the two additional (+/-25%) lines.
Yes, I showed a picture with a graphic in it. But what's your point?

6. ## Re: Graphfic type on Excel

You asked how to do something, Zbor showed you how. I guess I'm wondering what question remains unanswered.

7. ## Re: Graphfic type on Excel

Originally Posted by shg
You asked how to do something, Zbor showed you how. I guess I'm wondering what question remains unanswered.
But it wasn't showed exactly. In the picture, the trendline and the +-25% error lines adjust completely to the size of the graphic's square. I hope I've explained it right...

Nevertheless, my thanks again to Zbor, obviously.

9. ## Re: Graphfic type on Excel

Originally Posted by shg
Ok

Thank you very much and sorry for my ignorance.

Regards.

10. ## Re: Graphfic type on Excel

Originally Posted by Fernus
But it wasn't showed exactly. In the picture, the trendline and the +-25% error lines adjust completely to the size of the graphic's square. I hope I've explained it right...

Nevertheless, my thanks again to Zbor, obviously.
It's not clear from picture: is +-25% static value or dynamic? Does all points need to be included between +- lines? 90%? 75% Does they need to be equal +-25% or can be different +20%, -30%?

There is lot of things that your explanation don't cover.

If you want to get what you need you need to explain as better as possible.

Also, better way is to upload excel workbook (without sensitive data) instead of picture. Now we need to guess what data's could be used and spend more time to do data then to provide solution from it. Someone will help you to get your answer - make sure you help him to come to answer easier

11. ## Re: Graphfic type on Excel

You are right. But that was almost all the information I got too

95&#37; of the points must be included between those 2 error lines. And 25% is not static, it can change depending on those 95%.

Thank you for your help once again.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1