Scatter plot axis display problem

salconflu

New Member
Joined
Mar 2, 2010
Messages
13
I am trying to set up "empty" scatter plots that display counts on various dates when cells are populated with data.

When I select the date x-axis data it appears to the side of the Edit Series dialog box and the Select Data Source dialog box as dates, but the graph displays generic categorical values, 1, 2, 3 etc depending on how many values I have in my series.

I've search a number of forums and google for a similar situation but I'm having no luck. :confused:
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

salconflu

New Member
Joined
Mar 2, 2010
Messages
13
Additional Info: I notice the problem appears to have something to do with the first cell in the x-axis values being a reference to a formula. The formula evaluates the first record with data and subtracts 7 ie: =B6-7, where B6 is the first date with count data.
 

Forum statistics

Threads
1,171,591
Messages
5,876,336
Members
433,194
Latest member
mamidwar

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