I'm trying to print a Line Chart with data from a worksheet, but for some
reason the data that I am using this time will not cooperate.
I want a Range on the left side of the page and the Date at the bottom.
The problem:
When I give the range with the Wizzard the points aren't not given as points
in the table but are copied verbatum from the worksheet and placed upabove or
to the right of the Chart and the Range is given as 0.0 - 1.0.
I have had cases where the Line Chart is completly blank.
I suspect that the data worksheet may have something to do with it because I
have been able to get several worksheets to print as a Line Chart in the past
without too much difficulty.
Can anybody tell me what I'm doing wrong?

Make sure you don't have blank spaces in your data range. Also make sure
that any numerical data is recognized by Excel as numeric (and not stored as
text).

You may have to explicitly define the ranges used in the chart. From the
Chart menu, select Source Data, and click on the Series tab. Make sure you
have as many series as you expect; delete any extras. Select a series, then
use the Y Values and X Category Labels input boxes to select the appropriate
ranges.

You may want to try this as an XY chart instead of a Line chart. The two may
look similar, and you can make either connect the points with a line, but
they treat their X variable differently.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Warp4Dennis" wrote in message
...
I'm trying to print a Line Chart with data from a worksheet, but for some
reason the data that I am using this time will not cooperate.
I want a Range on the left side of the page and the Date at the bottom.
The problem:
When I give the range with the Wizzard the points aren't not given as
points
in the table but are copied verbatum from the worksheet and placed upabove
or
to the right of the Chart and the Range is given as 0.0 - 1.0.
I have had cases where the Line Chart is completly blank.
I suspect that the data worksheet may have something to do with it because
I
have been able to get several worksheets to print as a Line Chart in the
past
without too much difficulty.
Can anybody tell me what I'm doing wrong?

"Jon Peltier" wrote:

Make sure you don't have blank spaces in your data range. Also make sure
that any numerical data is recognized by Excel as numeric (and not stored as
text).

You may have to explicitly define the ranges used in the chart. From the
Chart menu, select Source Data, and click on the Series tab. Make sure you
have as many series as you expect; delete any extras. Select a series, then

Using the Chart Wizard form "Insert":
I don't seem to have any controll over the "series". For some reason the
Chart Wizard uses every value from the Spread Sheet as a series entry from
either Column one or Colum two so I have as a result 255 series.

use the Y Values and X Category Labels input boxes to select the appropriate
ranges.

Labels are the least of my worys, I know how to change them. My questions
are; Why is the wrong scale used? Does the wrong scale prevent the "Data"
from being ploted? Does it matter when the scale is changed?

You may want to try this as an XY chart instead of a Line chart. The two may
look similar, and you can make either connect the points with a line, but
they treat their X variable differently.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Warp4Dennis" wrote in message
...
I'm trying to print a Line Chart with data from a worksheet, but for some
reason the data that I am using this time will not cooperate.
I want a Range on the left side of the page and the Date at the bottom.
The problem:
When I give the range with the Wizzard the points aren't not given as
points
in the table but are copied verbatum from the worksheet and placed upabove
or
to the right of the Chart and the Range is given as 0.0 - 1.0.
I have had cases where the Line Chart is completly blank.
I suspect that the data worksheet may have something to do with it because
I
have been able to get several worksheets to print as a Line Chart in the
past
without too much difficulty.
Can anybody tell me what I'm doing wrong?

Dear Sir:
I seem to be aimming at a moving target when I select the Chart Wizard from
"Insert"!
The Excel spread sheet has three colums. Only
two of the three are of interest.
Colum one, which are 255 dates starting with the last day of the year and
decending to the first day of the year, exactly the opposite of how people
read charts and how I want them.
Colum two, which are 255 pieces of data in a range of numbers from 15.00 to
45.00.
For argument's sake let's say that I press F11.
The results are as follows;
At the top where the "Name" should be is the last entry in the spread sheet
with the Date at the beginning separated from the Data with a space.
In the Right margin appears the same as the top or "Name".
The bottom is divided into exactly two parts with the name of Colum one
(Date) on the left side and the name of Colum two (Close) on the right.
I chose F11 because it seams to be the only repeatable method of using the
Cart Wizard. Using a Line chart or the XY chart makes no difference the
results are the same.
Selecting the Chart Wizard from "Insert" produces unpridictable results.

Where is your data coming from? If you've imported it from somewhere, I
suspect that it came in as text and Excel does not interpret it as
numerical. This is the only way I can get anything similar to your bad
results.

In any of your charts, go to the Chart menu, select Source Data, and click
on the Series tab. How many series are listed? What are the indicated ranges
for Name, Values, and Category Axis Labels? If the Name includes more than a
single cell, or if there are more than one series, or if the Values and
Labels ranges are awry, it provides further backup to my hypothesis, that
your data are all categorical and not numerical.

Convert text to number using this procedu

Copy a blank cell
Select the cells to convert
Select Paste Special from Edit menu
Choose Operation - Add
Click OK

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Warp4Dennis" wrote in message
...


"Jon Peltier" wrote:

Make sure you don't have blank spaces in your data range. Also make sure
that any numerical data is recognized by Excel as numeric (and not stored
as
text).

You may have to explicitly define the ranges used in the chart. From the
Chart menu, select Source Data, and click on the Series tab. Make sure
you
have as many series as you expect; delete any extras. Select a series,
then

Using the Chart Wizard form "Insert":
I don't seem to have any controll over the "series". For some reason the
Chart Wizard uses every value from the Spread Sheet as a series entry from
either Column one or Colum two so I have as a result 255 series.

use the Y Values and X Category Labels input boxes to select the
appropriate
ranges.

Labels are the least of my worys, I know how to change them. My questions
are; Why is the wrong scale used? Does the wrong scale prevent the "Data"
from being ploted? Does it matter when the scale is changed?

You may want to try this as an XY chart instead of a Line chart. The two
may
look similar, and you can make either connect the points with a line, but
they treat their X variable differently.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Warp4Dennis" wrote in message
...
I'm trying to print a Line Chart with data from a worksheet, but for
some
reason the data that I am using this time will not cooperate.
I want a Range on the left side of the page and the Date at the bottom.
The problem:
When I give the range with the Wizzard the points aren't not given as
points
in the table but are copied verbatum from the worksheet and placed
upabove
or
to the right of the Chart and the Range is given as 0.0 - 1.0.
I have had cases where the Line Chart is completly blank.
I suspect that the data worksheet may have something to do with it
because
I
have been able to get several worksheets to print as a Line Chart in
the
past
without too much difficulty.
Can anybody tell me what I'm doing wrong?

Dear Sir:
I seem to be aimming at a moving target when I select the Chart Wizard
from
"Insert"!
The Excel spread sheet has three colums. Only
two of the three are of interest.
Colum one, which are 255 dates starting with the last day of the year and
decending to the first day of the year, exactly the opposite of how people
read charts and how I want them.
Colum two, which are 255 pieces of data in a range of numbers from 15.00
to
45.00.
For argument's sake let's say that I press F11.
The results are as follows;
At the top where the "Name" should be is the last entry in the spread
sheet
with the Date at the beginning separated from the Data with a space.
In the Right margin appears the same as the top or "Name".
The bottom is divided into exactly two parts with the name of Colum one
(Date) on the left side and the name of Colum two (Close) on the right.
I chose F11 because it seams to be the only repeatable method of using the
Cart Wizard. Using a Line chart or the XY chart makes no difference the
results are the same.
Selecting the Chart Wizard from "Insert" produces unpridictable results.

"Jon Peltier" wrote:

Where is your data coming from? If you've imported it from somewhere, I
suspect that it came in as text and Excel does not interpret it as
numerical. This is the only way I can get anything similar to your bad
results.

The data is coming from the Internet and is sent to me as an Excel file.
But the problem is I can't confirm which file type (ie .cvs, .xla or .xls)
because Windows refuses to show the suffix even tho I told it to do so.

In any of your charts, go to the Chart menu, select Source Data, and click
on the Series tab. How many series are listed? What are the indicated ranges
for Name, Values, and Category Axis Labels? If the Name includes more than a
single cell, or if there are more than one series, or if the Values and
Labels ranges are awry, it provides further backup to my hypothesis, that
your data are all categorical and not numerical.

Convert text to number using this procedu

Copy a blank cell
Select the cells to convert
Select Paste Special from Edit menu
Choose Operation - Add
Click OK

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com

Jon, since the spreadsheet (datasheet) is 99 and 44/100% numerical, is there
a way to mark the file as being "numerical"? Is it possible to save the
datasheet with a new suffix? If so, which one?
_______


"Warp4Dennis" wrote in message
...


"Jon Peltier" wrote:

Make sure you don't have blank spaces in your data range. Also make sure
that any numerical data is recognized by Excel as numeric (and not stored
as
text).

You may have to explicitly define the ranges used in the chart. From the
Chart menu, select Source Data, and click on the Series tab. Make sure
you
have as many series as you expect; delete any extras. Select a series,
then

Using the Chart Wizard form "Insert":
I don't seem to have any controll over the "series". For some reason the
Chart Wizard uses every value from the Spread Sheet as a series entry from
either Column one or Colum two so I have as a result 255 series.

use the Y Values and X Category Labels input boxes to select the
appropriate
ranges.

Labels are the least of my worys, I know how to change them. My questions
are; Why is the wrong scale used? Does the wrong scale prevent the "Data"
from being ploted? Does it matter when the scale is changed?

You may want to try this as an XY chart instead of a Line chart. The two
may
look similar, and you can make either connect the points with a line, but
they treat their X variable differently.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Warp4Dennis" wrote in message
...
I'm trying to print a Line Chart with data from a worksheet, but for
some
reason the data that I am using this time will not cooperate.
I want a Range on the left side of the page and the Date at the bottom.
The problem:
When I give the range with the Wizzard the points aren't not given as
points
in the table but are copied verbatum from the worksheet and placed
upabove
or
to the right of the Chart and the Range is given as 0.0 - 1.0.
I have had cases where the Line Chart is completly blank.
I suspect that the data worksheet may have something to do with it
because
I
have been able to get several worksheets to print as a Line Chart in
the
past
without too much difficulty.
Can anybody tell me what I'm doing wrong?

Dear Sir:
I seem to be aimming at a moving target when I select the Chart Wizard
from
"Insert"!
The Excel spread sheet has three colums. Only
two of the three are of interest.
Colum one, which are 255 dates starting with the last day of the year and
decending to the first day of the year, exactly the opposite of how people
read charts and how I want them.
Colum two, which are 255 pieces of data in a range of numbers from 15.00
to
45.00.
For argument's sake let's say that I press F11.
The results are as follows;
At the top where the "Name" should be is the last entry in the spread
sheet
with the Date at the beginning separated from the Data with a space.
In the Right margin appears the same as the top or "Name".
The bottom is divided into exactly two parts with the name of Colum one
(Date) on the left side and the name of Colum two (Close) on the right.
I chose F11 because it seams to be the only repeatable method of using the
Cart Wizard. Using a Line chart or the XY chart makes no difference the
results are the same.
Selecting the Chart Wizard from "Insert" produces unpridictable results.

"Warp4Dennis" wrote in message
...

Where is your data coming from? If you've imported it from somewhere, I
suspect that it came in as text and Excel does not interpret it as
numerical. This is the only way I can get anything similar to your bad
results.

The data is coming from the Internet and is sent to me as an Excel file.
But the problem is I can't confirm which file type (ie .cvs, .xla or .xls)
because Windows refuses to show the suffix even tho I told it to do so.

Does the file even have a suffix? Does Windows do this for all of your
files? To undo it (hope I'm not repeating what you've already done) in
Windows Explorer's Tools menu, choose Folder Options, click on the View tab,
and uncheck the Advanced Setting box for Hide Extensions For Known File
Types.

When you do a Save As in Excel, what file type is offered? Excel should
start with the same type as the original file, so opening a CSV file would
make Excel offer to save it as another CSV file.

Jon, since the spreadsheet (datasheet) is 99 and 44/100% numerical, is
there
a way to mark the file as being "numerical"? Is it possible to save the
datasheet with a new suffix? If so, which one?

Save as a regular Excel workbook. It should by default have an extension of
..xls.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______