Excel graph problem

Hi Johnson,

Thanks for your response.

As exactly u said, both trendline equation and R square value changes.

Rightnow, I am just using the numbers only.

What should I do if I had to represent the numbers with units without using the title box.

Sainath

Hi biosainath,
What you can do is format each axis separately.
Say you want your X axis values to look like, for example "50 grams"
(not including the speech marks of course), then
1.double click the X axis to open the Format Axis dialog.
2.Click on that dialog's Number Tab
3.In the Category box: select Custom
4.In the Type box, where you should see General change it to
General"grams".Check that the Sample box shows the correct format.
5. Click OK

Repeat this process with the other axis if needed.

Hope this is what you're after.

The only other way that I know of only gives you the units in the axis
titles, which you can get to, after selecting the chart, Chart>Chart
Options>Titles tab>then type units into Value (X) axis: and Value (Y)
axis boxes.

Ken Johnson

Hi Johnson,

Instead of the "CUSTOM" and "GENERAL", I used Text option.

It was working.

Thats a Lot.

U simply solved my problem.

Sainath

Hi biosainath,
You're welcome. Thanks for the feedback.
Ken Johnson

Ken:

My problem is not so complicated but very frustrating none the less. When
drawing a line in my excel spreadsheet and using line colors to identify
them, if I move down a page or up a page, the lines dissapear? The line and
colors no longer stay put in the spreadsheet? I have not changed anything,
have no viruses so what is going on.

"Ken Johnson" wrote:

> Hi biosainath,
> You're welcome. Thanks for the feedback.
> Ken Johnson
>
>