swap x & y axis

egglesh

New Member
Joined
Dec 9, 2005
Messages
1
Did a search and found some info on this but it didn't exactly get me what I needed.

Basically, I'm creating a financial calendar of events. I'd like the days on the horizontal axis (days would start with -15, or "day -15", and go to +15, or "day +15"... Zero being the first day of the month)

On the vertical axis would be the activities (ie. prepare monthly calendar, record commissions, hold pre-close meeting, etc...)

I have two columns on my spreadsheet; 1.) Target Date 2.) Actual Date

I have tried to get this to work for 3 days and can't figure it out! Any ideas??
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Watch MrExcel Video

Forum statistics

Threads
1,118,084
Messages
5,570,128
Members
412,305
Latest member
Mozz
Top