View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.misc
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Excel Line Chart

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
_______