Plotting diagonal axis in Excel or rotating charts
 

Hello
I have some data that I would like to plot on an Excel chart that has a
diagonal axis. I wish to keep the chart as an object on an Excel worksheet
(as opposed to exporting the chart to another MS application).

Is it possible to do this by a) plotting diagonally or b) subsequently
rotating the chart in the worksheet.

Many thanks in advance

Plotting diagonal axis in Excel or rotating charts
 

One idea: make the chart in normal way. Hold SHIFT key, use Edit|Copy
Picture; now Paste
Now you have a picture of the chart and like all pictures you can rotate it.

If you really want to plot on the x=y line, are you ready for the math
lesson?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Mandley D" wrote in message
...
Hello
I have some data that I would like to plot on an Excel chart that has a
diagonal axis. I wish to keep the chart as an object on an Excel worksheet
(as opposed to exporting the chart to another MS application).

Is it possible to do this by a) plotting diagonally or b) subsequently
rotating the chart in the worksheet.

Many thanks in advance

Plotting diagonal axis in Excel or rotating charts
 

Dear Bernard
Many thanks for this advice. My maths isn't what it used to be but but I'm
always up for a challenge. Guidance on taking this further would be
appreciated.

Many thanks
David

"Bernard Liengme" wrote:

One idea: make the chart in normal way. Hold SHIFT key, use Edit|Copy
Picture; now Paste
Now you have a picture of the chart and like all pictures you can rotate it.

If you really want to plot on the x=y line, are you ready for the math
lesson?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Mandley D" wrote in message
...
Hello
I have some data that I would like to plot on an Excel chart that has a
diagonal axis. I wish to keep the chart as an object on an Excel worksheet
(as opposed to exporting the chart to another MS application).

Is it possible to do this by a) plotting diagonally or b) subsequently
rotating the chart in the worksheet.

Many thanks in advance

Plotting diagonal axis in Excel or rotating charts
 

The equations for a rotational transformation by angle A (in anticlockwise
direction) are
x' = xCos(A) - ySin(A) and y' = ySin(A) + xCos(A)

You want to plot on a diagonal (A = 45º) I know SIN(45) = COS(45) but let's
keep thing general
In F1:H1 enter this:
Angle SinA CosA
in F2 enter 45
in G2 enter =SIN(RADIANS(F2)) and in H2 =COS(RADIANS(F2))
Select F1:H2; use Insert|Name to name the cells

Now we will plot a square on the x-axis,
In A1:B1 enter x and y as headers
The x values are 2, 4, 4, 2, 2
The y values are 0, 0, 2, 2, 0
Make an XY plot - you get a 'box' on the x-axis

In C1 and D1 use headers x' and y'
In C2 enter =A2*cosA-B2*sinA; in D2 enter =B2*sinA+A2*cosA
Copy these down to row 6

Select C2:D6; use Copy tool; click chart; use Edit|Paste Special
and indicate New Series with x-values in first column

Now you have the same box rotated. The box lies on the x=y line (what you
called the diagonal)
Any use?
All this is a bit esoteric so if you want to leave the newsgroup and send me
private mail that's OK with me
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Mandley D" wrote in message
...
Dear Bernard
Many thanks for this advice. My maths isn't what it used to be but but
I'm
always up for a challenge. Guidance on taking this further would be
appreciated.

Many thanks
David

"Bernard Liengme" wrote:

One idea: make the chart in normal way. Hold SHIFT key, use Edit|Copy
Picture; now Paste
Now you have a picture of the chart and like all pictures you can rotate
it.

If you really want to plot on the x=y line, are you ready for the math
lesson?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Mandley D" wrote in message
...
Hello
I have some data that I would like to plot on an Excel chart that has a
diagonal axis. I wish to keep the chart as an object on an Excel
worksheet
(as opposed to exporting the chart to another MS application).

Is it possible to do this by a) plotting diagonally or b) subsequently
rotating the chart in the worksheet.

Many thanks in advance

Plotting diagonal axis in Excel or rotating charts
 

Dear Bernard
Will digest this over the weekend and may get back to you on Monday with
questions

Yet again, many thanks
David

"Bernard Liengme" wrote:

The equations for a rotational transformation by angle A (in anticlockwise
direction) are
x' = xCos(A) - ySin(A) and y' = ySin(A) + xCos(A)

You want to plot on a diagonal (A = 45º) I know SIN(45) = COS(45) but let's
keep thing general
In F1:H1 enter this:
Angle SinA CosA
in F2 enter 45
in G2 enter =SIN(RADIANS(F2)) and in H2 =COS(RADIANS(F2))
Select F1:H2; use Insert|Name to name the cells

Now we will plot a square on the x-axis,
In A1:B1 enter x and y as headers
The x values are 2, 4, 4, 2, 2
The y values are 0, 0, 2, 2, 0
Make an XY plot - you get a 'box' on the x-axis

In C1 and D1 use headers x' and y'
In C2 enter =A2*cosA-B2*sinA; in D2 enter =B2*sinA+A2*cosA
Copy these down to row 6

Select C2:D6; use Copy tool; click chart; use Edit|Paste Special
and indicate New Series with x-values in first column

Now you have the same box rotated. The box lies on the x=y line (what you
called the diagonal)
Any use?
All this is a bit esoteric so if you want to leave the newsgroup and send me
private mail that's OK with me
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Mandley D" wrote in message
...
Dear Bernard
Many thanks for this advice. My maths isn't what it used to be but but
I'm
always up for a challenge. Guidance on taking this further would be
appreciated.

Many thanks
David

"Bernard Liengme" wrote:

One idea: make the chart in normal way. Hold SHIFT key, use Edit|Copy
Picture; now Paste
Now you have a picture of the chart and like all pictures you can rotate
it.

If you really want to plot on the x=y line, are you ready for the math
lesson?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Mandley D" wrote in message
...
Hello
I have some data that I would like to plot on an Excel chart that has a
diagonal axis. I wish to keep the chart as an object on an Excel
worksheet
(as opposed to exporting the chart to another MS application).

Is it possible to do this by a) plotting diagonally or b) subsequently
rotating the chart in the worksheet.

Many thanks in advance