show specific dates in Excel chart 1

[ashaikh05]

I'm creating a graph in Excel. Because the data only shows certain dates how do i customise the chart so it only shows the dates in the sheet and not every date between two periods?

Many thanks

 

[kjv1611]

Can you give us a "for instance"?

--

"If to err is human, then I must be some kind of human!" -Me

 

[ashaikh05]

for instance

The source data contains events which occured Tuesday 1st, Wednesday 2nd and Friday 4th. There is no data for the other dates

When i make the chart it includes the dates which are not in the table e.g. Thursday 3rd, Saturday 6th.

Now because the chart contains data over a 3 month period and i've only got events recorded against 3 days of the week, each date shows up on the chart which makes it very long given the fact that over half of it is irrelevant.

Hope that helps

 

[mintjulep]

One option would be to use AutoFilter to filter and hide the irrelevant data, then Plot only visible cells.

 

[ashaikh05]

I can't use AutoFilter because the data is only those dates when an event occured.

 

[SkipVought]

Hi,

Your x-axis can be EITHER a CATEGORY or TIME VALUE. You select this in Chart Options

The difference is that CATEGORY plots each value as an isolated item without regard to it relative value, where TIME is relative...
[tt]
CAT: 1 3 6
TIM: 1 . 3 . . 6
[/tt]


Skip,

_[red][/red]

 

[ashaikh05]

sorted

thanks

 

[MeGustaXL]

Skip-A-Dee-DooDah! He's done it again!

That's so useful. yet obvious it deserves a STAR-like object

Chris

Servo vestri abbas etiam quod ego mos arcesso unguentum

 

[SkipVought]

Thanx!

Skip-a-dee-ay ;-)

Skip,

_[red][/red]