"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.