A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

chart frustrations



 
 
Thread Tools Display Modes
  #1  
Old October 31st, 2009, 06:08 PM posted to microsoft.public.excel.charting
Steve
external usenet poster
 
Posts: 2,662
Default 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  
Old October 31st, 2009, 06:28 PM posted to microsoft.public.excel.charting
Bernard Liengme
external usenet poster
 
Posts: 4,085
Default 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  
Old October 31st, 2009, 07:38 PM posted to microsoft.public.excel.charting
Steve
external usenet poster
 
Posts: 2,662
Default 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  
Old October 31st, 2009, 10:05 PM posted to microsoft.public.excel.charting
Steve
external usenet poster
 
Posts: 2,662
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:37 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.