how to create a diagram in excel

Posted on 2013-09-08
Medium Priority
Last Modified: 2013-09-08
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.
Question by:c_hockland
  • 2
LVL 12

Accepted Solution

duttcom earned 2000 total points
ID: 39475458
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)

Author Comment

ID: 39475470
perfect ! many thanks . I worked like a charm.
LVL 12

Expert Comment

ID: 39475475
Glad to help!

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This holiday season, we’re giving away the gift of knowledge—tech knowledge, that is. Keep reading to see what hacks, tips, and trends we have wrapped and waiting for you under the tree.
What to do if a split doesn't fit? Or a bunch of invoice lines must be rounded while the sum must match a total? It takes a little, but - when done - it is extremely easy to implement.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

587 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question