# tough scatter plot question

#### jferri

##### Board Regular
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
Are your dates true dates or text?
Can you change their look by formatting? If so, they are True Dates.

#### jferri

##### Board Regular
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
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

it is formatted as date.

#### Datsmart

##### Well-known Member
Help me out here.
Define, "they plot all weird".

#### jferri

##### Board Regular
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
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".

Replies
4
Views
290
Replies
0
Views
181
Replies
2
Views
309
Replies
0
Views
538
Replies
0
Views
177

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.

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.

### Which adblocker are you using?

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

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