Generate Excel Scatter Diagram
 

On Jun 27, 2:51*am, "Mike Middleton" wrote:
andyeali or Moms *-

(1) What do you mean by "completely throws off the y axis"?

(2) Are you sure you are using an XY (Scatter) chart type?

(3) You posted in microsoft.public.excel.programming instead of
microsoft.public.excel.charting. Are you using menu commands, or are you
writing VBA code?

(4) Which version of Excel?

(5) If you think your dates are really Excel dates and not text, and if you
think this is a charting problem, I suggest you post a small data set with
steps to replicate the problem you are seeing.

(6) An excellent source for Excel charts is Jon Peltier's web site atwww.peltiertech.com, with an index athttp://www.peltiertech.com/Excel/Charts/ChartIndex.html

- Mike Middletonhttp://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel

wrote in message

...
On Jun 26, 3:21 pm, "Mike Middleton" wrote:





Moms -

Perhaps start by reviewing Chip Pearson's information:

http://www.cpearson.com/excel/datetime.htm

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel

wrote in message

....

Hi,
I'm creating an excel scatter diagram but when it's finished the dates
start at the year 1900 and does not reflect the dates from the
source. Any ideas how to adjust this?
Regards,
Moms- Hide quoted text -

- Show quoted text -

Mike,

I understand. *I got the dates to show on the x axis but because I
entered the values that excel stores the dates as it completely throws
off the y axis. *Is there a work around for this?

Regards,
Andy- Hide quoted text -

- Show quoted text -

Mike,

I appreciate your input. I'll try and post it on
microsoft.public.excel.charting. However, to answer your questions:

(1) What do you mean by "completely throws off the y axis"? Not data
shows up on the chart.

(2) Are you sure you are using an XY (Scatter) chart type? Yes

(4) Which version of Excel? Office Excel 2003 SP3

Again,
Thanks