Automatic Timeline in Excel 1

[DeLaMartre]

I doubt there is a solution, but here is what I would like to do:

Excel worksheet with a column of dates and a column of text (5-6 words). I would like to create a chart that has the dates on the x-axis and the "y-axis" values be the text shown in a 45 degree angle. I tried using a scatterplot and revealing the labels, but no luck.

Any thoughts would be greatly appreciated.

Thanks,

-Bob in California

 

[SkipVought]

Hi,

I'd use a spreadsheet solution rather than a Chart.

First, I named the date range rDate and the name range as rName using Insert/Name/Create - Create name in TOP row.

The "x-axis" is a row in the sheet.

The first cell is B1
[tt]
=MIN(rDate)
[/tt]
formatted as a Date Format.

The next column value is...
[tt]
=B1+7
[/tt]
if you wanted the scale to be weeks.

The next row is
[tt]
=MATCH(B1,rDate,1)
[/tt]
and copied across. This row can be hidden.

The 3rd row is the names...
[tt]
=IF(A2<>B2,INDEX(Name,B2,1),"")
[/tt]
Format this row to slant the text as desired.

Flip the rows if you need the names above the dates.




Skip,

_{[red]Be advised:[/red]We know Newton's 3 Laws. But did you hear about the [red]FOURTH???[/red]
Only ONE fig per cookie!}

 

[DeLaMartre]

Skip,

Thanks so much for the brilliant solution! The considerable amount of time you spent in replying is greatly appreciated.

Another star for a true star.

Regards,

-Bob in California