Excel Chart

**K5ILF** · 03-29-2007, 09:06 PM

I am totally frustrated trying to do something simple with Excel. I cant get the chart feature to show a graph similar to a "U" or hyperbola----when I enter the following numbers, I get two lines, not a curve---

27.000
27.736 2.0
28.463 1.5
29.700
29.947 2.0
The graph should be a slight "U" shaped curve, with the items in column A on the bottom, left to right.
I sure could use a bit of assistance.

bill in las cruces

I know the answer is really simple, but I can't figure it out today!

**Bryan Hessey** · 03-30-2007, 02:12 AM

Originally Posted by K5ILF

I am totally frustrated trying to do something simple with Excel. I cant get the chart feature to show a graph similar to a "U" or hyperbola----when I enter the following numbers, I get two lines, not a curve---

27.000
27.736 2.0
28.463 1.5
29.700
29.947 2.0
The graph should be a slight "U" shaped curve, with the items in column A on the bottom, left to right.
I sure could use a bit of assistance.

bill in las cruces

I know the answer is really simple, but I can't figure it out today!

Hi,

totally unsure.

the only way I can see that you would make a U shape is to (assuming those figures are in A1:B5) in B1 put 3, and in B4 put 1.3 then in C1 put =A1*B1 and formula fill that downwards, then line-chart C1:C5 and set the Data series to Smooth Line.

hth
---

**K5ILF** · 03-30-2007, 11:05 AM

Thanks Brian for the reply: I don't think I am describing the problem very well. Perhaps if I tell you that this graph is a description of frequency versus SWR (standing wave). It is so simple that it has become difficult! The frequency between 27.736 mHz and 29.947 mHz has the lowest SWR at 28.463 mHz which is 1.5. At the frequencies of 27.736 mHz and 29.947 mHz the SWR is 2.0 The graph should have the frequency across the bottom and the SWR up the left side. The graph would have 3 points indicated and connected with a smooth line. I know I am not describing it well, but it seems that the most simple is the most complicated sometimes. I hope I have not confused you. I really appreciate your response. Thank you.

bill in las cruces

**MrShorty** · 03-30-2007, 11:10 AM

What kind of chart are you using? I expect you want an XY scatter plot (which uses numeric X data), and are somehow getting a Line chart (which uses categorical "x data"). And, for whatever reason, when you create the Line chart, Excel assumes you have two different series to plot against its default category set (1,2,3,...). The first thing I would suggest is to make sure you are using the appropriate chart for the application.

**Bryan Hessey** · 03-30-2007, 11:22 AM

Originally Posted by K5ILF

Thanks Brian for the reply: I don't think I am describing the problem very well. Perhaps if I tell you that this graph is a description of frequency versus SWR (standing wave). It is so simple that it has become difficult! The frequency between 27.736 mHz and 29.947 mHz has the lowest SWR at 28.463 mHz which is 1.5. At the frequencies of 27.736 mHz and 29.947 mHz the SWR is 2.0 The graph should have the frequency across the bottom and the SWR up the left side. The graph would have 3 points indicated and connected with a smooth line. I know I am not describing it well, but it seems that the most simple is the most complicated sometimes. I hope I have not confused you. I really appreciate your response. Thank you.

bill in las cruces

Hi,
so you are charting the Standing Wave Ratio against the frequency, but your original figures showed the SWR for only 3 readings, hardly enough to be able to plot anything except a lne.

If you complete the other two readings and then use the SWR as the Y and the frequency as the x, and set the line to 'Smooth' then you should go close,

see the attached

added, you need to add the category x labels as A2:A6

---

**K5ILF** · 03-30-2007, 11:58 AM

Thanks Brian and all, I finally had a mental break-though and realize what I was, or was NOT, doing. I was using the wrong type of chart. Thank you so much.

bill in las cruces

**Bryan Hessey** · 03-30-2007, 05:21 PM

Originally Posted by K5ILF

Thanks Brian and all, I finally had a mental break-though and realize what I was, or was NOT, doing. I was using the wrong type of chart. Thank you so much.

bill in las cruces

good to see your problemn resolved, and thanks for the response.

---