software

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 advanceOne 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

quot;Mandley Dquot; gt; wrote in message
...
gt; Hello
gt; I have some data that I would like to plot on an Excel chart that has a
gt; diagonal axis. I wish to keep the chart as an object on an Excel worksheet
gt; (as opposed to exporting the chart to another MS application).
gt;
gt; Is it possible to do this by a) plotting diagonally or b) subsequently
gt; rotating the chart in the worksheet.
gt;
gt; Many thanks in advance
gt;
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

quot;Bernard Liengmequot; wrote:

gt; One idea: make the chart in normal way. Hold SHIFT key, use Edit|Copy
gt; Picture; now Paste
gt; Now you have a picture of the chart and like all pictures you can rotate it.
gt;
gt; If you really want to plot on the x=y line, are you ready for the math
gt; lesson?
gt; --
gt; Bernard V Liengme
gt; www.stfx.ca/people/bliengme
gt; remove caps from email
gt;
gt; quot;Mandley Dquot; gt; wrote in message
gt; ...
gt; gt; Hello
gt; gt; I have some data that I would like to plot on an Excel chart that has a
gt; gt; diagonal axis. I wish to keep the chart as an object on an Excel worksheet
gt; gt; (as opposed to exporting the chart to another MS application).
gt; gt;
gt; gt; Is it possible to do this by a) plotting diagonally or b) subsequently
gt; gt; rotating the chart in the worksheet.
gt; gt;
gt; gt; Many thanks in advance
gt; gt;
gt;
gt;
gt;

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 C26; 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

quot;Mandley Dquot; gt; wrote in message
...
gt; Dear Bernard
gt; Many thanks for this advice. My maths isn't what it used to be but but
gt; I'm
gt; always up for a challenge. Guidance on taking this further would be
gt; appreciated.
gt;
gt; Many thanks
gt; David
gt;
gt; quot;Bernard Liengmequot; wrote:
gt;
gt;gt; One idea: make the chart in normal way. Hold SHIFT key, use Edit|Copy
gt;gt; Picture; now Paste
gt;gt; Now you have a picture of the chart and like all pictures you can rotate
gt;gt; it.
gt;gt;
gt;gt; If you really want to plot on the x=y line, are you ready for the math
gt;gt; lesson?
gt;gt; --
gt;gt; Bernard V Liengme
gt;gt; www.stfx.ca/people/bliengme
gt;gt; remove caps from email
gt;gt;
gt;gt; quot;Mandley Dquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Hello
gt;gt; gt; I have some data that I would like to plot on an Excel chart that has a
gt;gt; gt; diagonal axis. I wish to keep the chart as an object on an Excel
gt;gt; gt; worksheet
gt;gt; gt; (as opposed to exporting the chart to another MS application).
gt;gt; gt;
gt;gt; gt; Is it possible to do this by a) plotting diagonally or b) subsequently
gt;gt; gt; rotating the chart in the worksheet.
gt;gt; gt;
gt;gt; gt; Many thanks in advance
gt;gt; gt;
gt;gt;
gt;gt;
gt;gt;
Dear Bernard
Will digest this over the weekend and may get back to you on Monday with
questions

Yet again, many thanks
David

quot;Bernard Liengmequot; wrote:

gt; The equations for a rotational transformation by angle A (in anticlockwise
gt; direction) are
gt; x' = xCos(A) - ySin(A) and y' = ySin(A) xCos(A)
gt;
gt; You want to plot on a diagonal (A = 45繙) I know SIN(45) = COS(45) but let's
gt; keep thing general
gt; In F1:H1 enter this:
gt; Angle SinA CosA
gt; in F2 enter 45
gt; in G2 enter =SIN(RADIANS(F2)) and in H2 =COS(RADIANS(F2))
gt; Select F1:H2; use Insert|Name to name the cells
gt;
gt; Now we will plot a square on the x-axis,
gt; In A1:B1 enter x and y as headers
gt; The x values are 2, 4, 4, 2, 2
gt; The y values are 0, 0, 2, 2, 0
gt; Make an XY plot - you get a 'box' on the x-axis
gt;
gt; In C1 and D1 use headers x' and y'
gt; In C2 enter =A2*cosA-B2*sinA; in D2 enter =B2*sinA A2*cosA
gt; Copy these down to row 6
gt;
gt; Select C26; use Copy tool; click chart; use Edit|Paste Special
gt; and indicate New Series with x-values in first column
gt;
gt; Now you have the same box rotated. The box lies on the x=y line (what you
gt; called the diagonal)
gt; Any use?
gt; All this is a bit esoteric so if you want to leave the newsgroup and send me
gt; private mail that's OK with me
gt; --
gt; Bernard V Liengme
gt; www.stfx.ca/people/bliengme
gt; remove caps from email
gt;
gt; quot;Mandley Dquot; gt; wrote in message
gt; ...
gt; gt; Dear Bernard
gt; gt; Many thanks for this advice. My maths isn't what it used to be but but
gt; gt; I'm
gt; gt; always up for a challenge. Guidance on taking this further would be
gt; gt; appreciated.
gt; gt;
gt; gt; Many thanks
gt; gt; David
gt; gt;
gt; gt; quot;Bernard Liengmequot; wrote:
gt; gt;
gt; gt;gt; One idea: make the chart in normal way. Hold SHIFT key, use Edit|Copy
gt; gt;gt; Picture; now Paste
gt; gt;gt; Now you have a picture of the chart and like all pictures you can rotate
gt; gt;gt; it.
gt; gt;gt;
gt; gt;gt; If you really want to plot on the x=y line, are you ready for the math
gt; gt;gt; lesson?
gt; gt;gt; --
gt; gt;gt; Bernard V Liengme
gt; gt;gt; www.stfx.ca/people/bliengme
gt; gt;gt; remove caps from email
gt; gt;gt;
gt; gt;gt; quot;Mandley Dquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; Hello
gt; gt;gt; gt; I have some data that I would like to plot on an Excel chart that has a
gt; gt;gt; gt; diagonal axis. I wish to keep the chart as an object on an Excel
gt; gt;gt; gt; worksheet
gt; gt;gt; gt; (as opposed to exporting the chart to another MS application).
gt; gt;gt; gt;
gt; gt;gt; gt; Is it possible to do this by a) plotting diagonally or b) subsequently
gt; gt;gt; gt; rotating the chart in the worksheet.
gt; gt;gt; gt;
gt; gt;gt; gt; Many thanks in advance
gt; gt;gt; gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;