- #1

yungman

- 5,624

- 226

You are using an out of date browser. It may not display this or other websites correctly.

You should upgrade or use an alternative browser.

You should upgrade or use an alternative browser.

- Thread starter yungman
- Start date

- #1

yungman

- 5,624

- 226

- #2

Antiphon

- 1,683

- 3

Yes it can. What version of Excel are you using?

- #3

- 18,824

- 8,996

Here is a video for Excel 2007

https://www.youtube.com/watch?v=XzJ2vuRWshQ

- #4

jtbell

Mentor

- 15,932

- 4,574

In Excel terminology, a graph is a "chart." For an XY graph from data points, choose the chart type "XY (Scatter)".

In the version that I use, Excel 2008 for Mac OS, by default the graph doesn't include vertical gridlines, but you can turn them on by clicking on the graph and then clicking the "Toolbox" icon in the toolbar, which contains various formatting options.

In the version that I use, Excel 2008 for Mac OS, by default the graph doesn't include vertical gridlines, but you can turn them on by clicking on the graph and then clicking the "Toolbox" icon in the toolbar, which contains various formatting options.

Last edited:

- #5

yungman

- 5,624

- 226

Yes it can. What version of Excel are you using?

I only have the Office Suit 2003!!! Old.

- #6

yungman

- 5,624

- 226

Hi

Thanks for the reply. I finally have the program and data that I want to plot the chart. Attached is the excel program. The chart I want to plot is Fig.2 and as you can see, I already plot out the graph. The thing that I don't know how to do is scaling the x axis ( horizontal). I need to plot the graph according to the voltage Vp in figure 2 that is high lighted in teal on top of of Fig. 2. The range is from 0 to 700V. I did search on the web and seems like only the Office 2010 can do that, not the 2003.

Anyone can help me on this?

Thanks

Alan

Thanks for the reply. I finally have the program and data that I want to plot the chart. Attached is the excel program. The chart I want to plot is Fig.2 and as you can see, I already plot out the graph. The thing that I don't know how to do is scaling the x axis ( horizontal). I need to plot the graph according to the voltage Vp in figure 2 that is high lighted in teal on top of of Fig. 2. The range is from 0 to 700V. I did search on the web and seems like only the Office 2010 can do that, not the 2003.

Anyone can help me on this?

Thanks

Alan

- #7

russ_watters

Mentor

- 21,866

- 8,840

The problem you are having is that you selected a "line chart". Change the chart type to "x-y scatter" and you'll be able to scale it by right clicking the axis and clicking "axis properties".

Looks like you'll also need to define the x-axis for each series, though.

- #8

yungman

- 5,624

- 226

The problem you are having is that you selected a "line chart". Change the chart type to "x-y scatter" and you'll be able to scale it by right clicking the axis and clicking "axis properties".

Looks like you'll also need to define the x-axis for each series, though.

Thanks for the reply. I tried, the x axis is labelled 0 to 12. If I change to 0 to 800, the chart shrink horizontally. The excel assigned 1 to 12 for me, but I need to assign the points according to the number on top of Fig.2 in teal color.

I need to label x axis from 0 to 800 and plot the points at x= 43.75, 65.625, 87.5, 175 etc. This is the row that is teal color in Fig.2.

Thanks

Alan

Is there any way to do it? Attached is the updated exel file that I change to xy chart already.

- #9

r4z0r84

- 93

- 1

Reason you had incorrect "labels" is due to only selecting the data.

basically just required you to select the vp and vg lines aswell (only the numbers not the text) for it to display correctly.

I created this using Excel 2010, saved it as backwards compatible for you unsure if it is the correct graph you are after but you can use the current selection to create a new graph.

Hope this helped.

basically just required you to select the vp and vg lines aswell (only the numbers not the text) for it to display correctly.

I created this using Excel 2010, saved it as backwards compatible for you unsure if it is the correct graph you are after but you can use the current selection to create a new graph.

Hope this helped.

- #10

russ_watters

Mentor

- 21,866

- 8,840

You skipped step 1: change the chart type to x-y scatter.Thanks for the reply. I tried, the x axis is labelled 0 to 12. If I change to 0 to 800, the chart shrink horizontally. The excel assigned 1 to 12 for me, but I need to assign the points according to the number on top of Fig.2 in teal color.

I need to label x axis from 0 to 800 and plot the points at x= 43.75, 65.625, 87.5, 175 etc. This is the row that is teal color in Fig.2.

Thanks

Alan

Is there any way to do it? Attached is the updated exel file that I change to xy chart already.

Share:

- Last Post

- Replies
- 1

- Views
- 474

- Last Post

- Replies
- 2

- Views
- 383

- Last Post

- Replies
- 2

- Views
- 552

- Replies
- 3

- Views
- 358

- Replies
- 13

- Views
- 481

- Last Post

- Replies
- 10

- Views
- 917

- Replies
- 10

- Views
- 2K

- Last Post

- Replies
- 5

- Views
- 769

- Last Post

- Replies
- 19

- Views
- 2K

- Last Post

- Replies
- 3

- Views
- 380