Decimal Problem

**Jgreen** · 10-26-2007, 05:22 PM

Hello,
Im driving myself nuts trying to figure this out....I have a data table that is fine for the y axis however the numbers for the x axis are very small such as .002 etc......but when it appears on the graph it says 2000!!! I dont get it...I messed with the fixed decimal option.....that did nothing.....any help would be great!!!

thanks

**oldchippy** · 10-26-2007, 05:29 PM

Click on the axis, right click > Format Axis > Scale tab, and adjust it there.

**Jgreen** · 10-26-2007, 06:28 PM

I tried messing around with the scale but i didnt get anywhere.....any ideas...

**oldchippy** · 10-27-2007, 06:11 AM

Hello there,

It’s not exactly clear what you are trying to achieve from the information given. But if you can provide a small zipped sample of your data, then hopefully a solution can be found.

To post a zipped example, go to “My Documents” or wherever you have your file stored, right-click and “Send to > Compressed file”, then attach this zipped file to your post.

**Jgreen** · 10-29-2007, 11:03 AM

Heres the file....the problem is with the strain data.....and the strain axis....the strain data says .002...the strain axis says 2000...

Thanks

**shg** · 10-29-2007, 12:08 PM

Looks fine to me when I plot strain vs stress. See attached.

**Jgreen** · 10-29-2007, 12:33 PM

The numbers on that graph are correct....however the axis are backwards now.....Stress MUST be on the Y axis...and Strain MUST be on the X axis......the graph is upside down in your clip....

Thanks

**sweep** · 10-29-2007, 12:38 PM

Hi,

Highlight column D, and cut, then paste into column F. Then run the chart wizard.

**Jgreen** · 10-29-2007, 12:48 PM

I tried that but the numbers on the x axis are still in the thousands.......There must be some type of formatting setting thats off in my excel settings....Im Lost....

**shg** · 10-29-2007, 01:18 PM

Stress MUST be on the Y axis...and Strain MUST be on the X axis

Like this?

**Jgreen** · 10-29-2007, 04:23 PM

Yessss....now how exactly do I get my graph to look like that....

**shg** · 10-29-2007, 05:17 PM

All I did was edit the series to reverse the order of appearance of columns D and E.

**Jgreen** · 10-30-2007, 09:48 AM

THANK YOU!....I went into series at the beginning of the chart wizard and highlighted all the strain data and put it into the x axis setting......and it finally worked!!!...Im not sure why I had to do that but either way now I know if I have that problem again....Its been a while since I've used Excel and i needed some major brushing up...This forum is great

Thanks

**shg** · 10-30-2007, 09:50 AM

You're welcome, glad it worked for you.

Decimal Problem

LinkBack

Thread Tools

Rate This Thread

Display

Decimal Problem

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions