tough scatter plot question

jferri

Board Regular
Joined
Jun 24, 2003
Messages
58
can someone please help me create a scatter plot with one series as dates. i know this sounds simple, but the graph is converting the date series to numbers, and then plotting them as 1900 dates. help would b much appreciated.
 

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

Datsmart

Well-known Member
Joined
Jun 19, 2003
Messages
7,985
Are your dates true dates or text?
Can you change their look by formatting? If so, they are True Dates.
Please post a sample of your dates here.
 

jferri

Board Regular
Joined
Jun 24, 2003
Messages
58
they are real dates. for example, if you have two columns, a and b. in column a a series of 10 dates (assume a few of them are listed more than once) - also format column a for dates. column b has 10 values ranging from 1 to 10 - column b is formatted for numbers. if i create a xy scatter plot, and format the x axis to be dates, they plot all weird. it looks like the xy scatter plot converts the dates to numberic values, and then formats them back to the wrong dates.
 

Datsmart

Well-known Member
Joined
Jun 19, 2003
Messages
7,985
Right click the X axis and choose "Format Axis".
Click on Numer Tab.
What format is being used in the Category field?
Does changing it help?
 

jferri

Board Regular
Joined
Jun 24, 2003
Messages
58

ADVERTISEMENT

it is formatted as date.
 

jferri

Board Regular
Joined
Jun 24, 2003
Messages
58
converts the first date in the series to 1, and increments them from there, so when it plots on the graph as a date it starts with 1/0/1900, and increases from there.
 

Datsmart

Well-known Member
Joined
Jun 19, 2003
Messages
7,985
Try this:
Right click white chart area, choose "Chart Options"
On Axes Tab, under Category (X) axis
Click "Category" instead of "Automatic" or "Time-scale".
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,160
Messages
5,768,537
Members
425,480
Latest member
br400821

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top