how to create a diagram in excel

I need to plot a graph of Xcp/C as a function of a

i am attaching the values and a screenshot of how the plot should look like. Any help would be appreciated.
1.xls
2.PNG
c_hocklandAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

duttcomCommented:
It can be done in Excel 2010 this way-

Select the data from A3:G11 (the data table)

The choose Insert -> Charts -> Scatter (choose the scatter with smooth lines) to insert a graph of that data.

Right-click on the graph and choose Select Data. Remove all series except series 6. Give series 6 the name of your data (Xcp/C)

The y axis will still look odd, but you can alter its position by selecting the graph, going to the Layout tab in Chart Tools, click on Axes and select Primary Horizontal axis, More primary horizontal axis options. Down the bottom you will see Vertical axis crosses - that is where you can enter the position of the vertical axis in relation to the horizontal. Make any other changes to the horizontal axis (the graph will default to starting at -5 on the x axis and you might want to change it)
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
c_hocklandAuthor Commented:
perfect ! many thanks . I worked like a charm.
0
duttcomCommented:
Glad to help!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.