If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
chart frustrations
Good morning all.
I'm trying to help my wife make a chart for a class she's taking, and it appears that it's been far too long since I did one. I'm using Excel 2007. I have a 3 point data set. There is a time element-- I want that set along the bottom, across the horizontal. There is a compound concentration element-- I want the concentration values in the vertical, at left. Then, my graph lines, should be the concetrations per time measure. Presently, my data on my excel sheet is organized as follows. Time 0 5 10 15 20 Conc.'s sample1 0 0 0 0 0 sample2 0 10 20 100 50 sample3 0 100 200 300 500 sample4 0 20 30 0 1000 The chart is showing up with the correct lines as my "samples" And the time is showing up correctly. However, my datalines are not showing those values. It's as though they've picked up a completely different set of values. Then, it appears that 2007 has changed just enough that I can't see how to change the axis label names, chart title, etc..... I'm feeling like I'm starting from scratch, and I use to be really good with charts under office 97/2000. If this needs more clarification for anything, please let me know. Thank you for your helps.... |
#2
|
|||
|
|||
chart frustrations
Steve:
What do you mean by "data lines"? Hopefully you made an XY (non-smooth lines) chart Would be happy to help if you sent me a file - get my email addy from my website best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Steve" wrote in message ... Good morning all. I'm trying to help my wife make a chart for a class she's taking, and it appears that it's been far too long since I did one. I'm using Excel 2007. I have a 3 point data set. There is a time element-- I want that set along the bottom, across the horizontal. There is a compound concentration element-- I want the concentration values in the vertical, at left. Then, my graph lines, should be the concetrations per time measure. Presently, my data on my excel sheet is organized as follows. Time 0 5 10 15 20 Conc.'s sample1 0 0 0 0 0 sample2 0 10 20 100 50 sample3 0 100 200 300 500 sample4 0 20 30 0 1000 The chart is showing up with the correct lines as my "samples" And the time is showing up correctly. However, my datalines are not showing those values. It's as though they've picked up a completely different set of values. Then, it appears that 2007 has changed just enough that I can't see how to change the axis label names, chart title, etc..... I'm feeling like I'm starting from scratch, and I use to be really good with charts under office 97/2000. If this needs more clarification for anything, please let me know. Thank you for your helps.... |
#3
|
|||
|
|||
chart frustrations
Hi Bernard,
Thank you. Email on it's way, with attachment. I'll be in and out all afternoon, but will be checking back. Again-- big time thank you.... SteveB. "Bernard Liengme" wrote: Steve: What do you mean by "data lines"? Hopefully you made an XY (non-smooth lines) chart Would be happy to help if you sent me a file - get my email addy from my website best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Steve" wrote in message ... Good morning all. I'm trying to help my wife make a chart for a class she's taking, and it appears that it's been far too long since I did one. I'm using Excel 2007. I have a 3 point data set. There is a time element-- I want that set along the bottom, across the horizontal. There is a compound concentration element-- I want the concentration values in the vertical, at left. Then, my graph lines, should be the concetrations per time measure. Presently, my data on my excel sheet is organized as follows. Time 0 5 10 15 20 Conc.'s sample1 0 0 0 0 0 sample2 0 10 20 100 50 sample3 0 100 200 300 500 sample4 0 20 30 0 1000 The chart is showing up with the correct lines as my "samples" And the time is showing up correctly. However, my datalines are not showing those values. It's as though they've picked up a completely different set of values. Then, it appears that 2007 has changed just enough that I can't see how to change the axis label names, chart title, etc..... I'm feeling like I'm starting from scratch, and I use to be really good with charts under office 97/2000. If this needs more clarification for anything, please let me know. Thank you for your helps.... . |
#4
|
|||
|
|||
chart frustrations
Hi Bernard,
Got the workbook back. Thank you very, very much. This does in fact answer my "stuckness." Or, as I like to tease Gary's Student-- Ka-ching!!!! Yet another satisfied customer...... Best. SteveB. "Bernard Liengme" wrote: Steve: What do you mean by "data lines"? Hopefully you made an XY (non-smooth lines) chart Would be happy to help if you sent me a file - get my email addy from my website best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Steve" wrote in message ... Good morning all. I'm trying to help my wife make a chart for a class she's taking, and it appears that it's been far too long since I did one. I'm using Excel 2007. I have a 3 point data set. There is a time element-- I want that set along the bottom, across the horizontal. There is a compound concentration element-- I want the concentration values in the vertical, at left. Then, my graph lines, should be the concetrations per time measure. Presently, my data on my excel sheet is organized as follows. Time 0 5 10 15 20 Conc.'s sample1 0 0 0 0 0 sample2 0 10 20 100 50 sample3 0 100 200 300 500 sample4 0 20 30 0 1000 The chart is showing up with the correct lines as my "samples" And the time is showing up correctly. However, my datalines are not showing those values. It's as though they've picked up a completely different set of values. Then, it appears that 2007 has changed just enough that I can't see how to change the axis label names, chart title, etc..... I'm feeling like I'm starting from scratch, and I use to be really good with charts under office 97/2000. If this needs more clarification for anything, please let me know. Thank you for your helps.... . |
Thread Tools | |
Display Modes | |
|
|