Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help! My graphs sneezed!
Here's a new one for me: I am using stacked area graphs to describe ion fractionations for my graduate thesis. However, my aluminum data series won't behave: I think I have attached sneeze.doc for your viewing pleasure. If not, please share the best way to post a graph. Anyway, the green polkadot area that represents Al extends beyond the x axis on the left side over the y axis intercept. None of the other data series are doing this. I have checked my data and the same # of cells have been chosen for the y-axis for each series, and my x-axis cells are the same for all. Now the kicker of it is that I have two worksheets that each have a separate graph (one for each stream) and graphs from both worksheets are screwing up Aluminum. Not calcium or hydrogen, just aluminum series. This does not appear on the excell sheet. Only when I copy (either as a picture or as a chart object; tried both ways) into my thesis. Now, I have set my x-axis minimum to ~1989 and my data go back to early 1989. SO I think that the extra booger bleeding over my y-axis is just showing all of the data. I can't figure out why though. Is the easiest fix to just delete the data I am not using, copy the graphs over, and then put the data back? +-------------------------------------------------------------------+ |Filename: sneeze.doc | |Download: http://www.excelforum.com/attachment.php?postid=3703 | +-------------------------------------------------------------------+ -- triscuit ------------------------------------------------------------------------ triscuit's Profile: http://www.excelforum.com/member.php...o&userid=26410 View this thread: http://www.excelforum.com/showthread...hreadid=396827 |
#2
|
|||
|
|||
No one will open an attached file. Send it to me my personal email.
I will have a look and reply (I'm a retired chem prof) -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "triscuit" wrote in message ... Here's a new one for me: I am using stacked area graphs to describe ion fractionations for my graduate thesis. However, my aluminum data series won't behave: I think I have attached sneeze.doc for your viewing pleasure. If not, please share the best way to post a graph. Anyway, the green polkadot area that represents Al extends beyond the x axis on the left side over the y axis intercept. None of the other data series are doing this. I have checked my data and the same # of cells have been chosen for the y-axis for each series, and my x-axis cells are the same for all. Now the kicker of it is that I have two worksheets that each have a separate graph (one for each stream) and graphs from both worksheets are screwing up Aluminum. Not calcium or hydrogen, just aluminum series. This does not appear on the excell sheet. Only when I copy (either as a picture or as a chart object; tried both ways) into my thesis. Now, I have set my x-axis minimum to ~1989 and my data go back to early 1989. SO I think that the extra booger bleeding over my y-axis is just showing all of the data. I can't figure out why though. Is the easiest fix to just delete the data I am not using, copy the graphs over, and then put the data back? +-------------------------------------------------------------------+ |Filename: sneeze.doc | |Download: http://www.excelforum.com/attachment.php?postid=3703 | +-------------------------------------------------------------------+ -- triscuit ------------------------------------------------------------------------ triscuit's Profile: http://www.excelforum.com/member.php...o&userid=26410 View this thread: http://www.excelforum.com/showthread...hreadid=396827 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
graphs showing unwanted zero values | Excel Discussion (Misc queries) | |||
Automate Excel to powerpoint - Graphs along with Datasheet (not workbook) | Charts and Charting in Excel | |||
2 graphs on 1 single chart cheet | Charts and Charting in Excel | |||
Line Graphs and Bar Graphs | Excel Discussion (Misc queries) | |||
Graphs and sheet referencing? | Excel Worksheet Functions |