Is it possible the values are numbers stored as text? They will plot as
zeros until you convert them.
It didn't help. The cells were marked "General". Changing to "number"
for
Column B made no difference that I could detect.
If the numbers are stored as text, the cell's number format will not
necessarily help. To convert cells, copy a blank cell, select the cells to
convert, go to Edit menu, Paste Special, choose the Addition Operation
option, and press OK.
That is the Data from Column
B is not ploted and the Range still remains the same, 0.0 to 1.0.
The values for Column A appear at the bottom of the Chart where they
should
be.
Are these text labels or numbers? What kind of chart?
I would presume that it makes no difference where the VBA information is
entered, that is in the "Chart Wizard" step 2 you have a choise. "Data
Range" and "Series".
Since Excel understands VBA, is it possible that I have inadvertantly left
out
something from the Series "Value:" data that I gave?
Value: ='Historical Data'!$B$2:$B$256
What good is a "Pivot" chart or table?
I don't know what you're asking.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______