#1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1,814
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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 4,393
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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1,814
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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1,814
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....


.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
IRR Calculation Frustrations jkramos2005 Excel Discussion (Misc queries) 2 December 3rd 08 09:01 PM
Concatenation frustrations.... Steve P[_2_] Excel Worksheet Functions 8 November 17th 08 09:54 PM
irr, xirr, npv frustrations Zachary Chan Excel Worksheet Functions 4 October 25th 05 04:41 AM
DSUM frustrations Paul Adams Excel Worksheet Functions 0 November 12th 04 11:07 AM
DSUM frustrations Paul Adams Excel Worksheet Functions 3 November 12th 04 10:59 AM


All times are GMT +1. The time now is 11:32 AM.

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

About Us

"It's about Microsoft Excel"