Generate Excel Scatter Diagram

  • Thread starter Thread starter andyeali
  • Start date Start date
A

andyeali

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
 
Click on the axis you want to change. For example the X-axis, the Right
Click it and select Format Axis. Then you can change the Min and Max of the
X-Axis. Plus you can change other things as well, you will see.

Hope this helps!
 
Click on the axis you want to change.  For example the X-axis, the Right
Click it and select Format Axis.  Then you can change the Min and Max of the
X-Axis.  Plus you can change other things as well, you will see.

Hope this helps!
--
Cheers,
Ryan





- Show quoted text -
Click to expand...

Ryan,

I appreciate your response. I've tried that but I'm dealing with two
columns and one of them contains dates (for e.g. 01/15/2008). The
date values are shown on the x axis and instead of seeing 1/15/2008
I'm seeing 1/15/1900. Have you come across this issue before?

Regards,
Andy
 
This worked for me. Try this. Format the cells the dates are located and
then format the chart axis to a date. Then manually type in the Min and Max
in Number Format.

Hope that works for you!
 
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 at
www.peltiertech.com, with an index at
http://www.peltiertech.com/Excel/Charts/ChartIndex.html

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



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






- Show quoted text -
Click to expand...

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







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 -
Click to expand...

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel to Visio 1
X Y Scatter Chart - Dates on X axis starting at 1900 1
Organization tree/diagram on drag&drop basis. 2
problem with scatter diagram excel 2007 2
AddDiagram Not woring in Excel 2007 1
XY Scatter Chart with Crosshair 2
Venn diagram macro in VBA. 1
date in scatter chart excel 2003 1

Back
Top