Charting date ranges

kalbrecht31

New Member
Joined
Oct 23, 2006
Messages
2
I have a customer catalog that I export from Crystal into Excel. I need to graph price changes based on from and to dates. My manager wants to see the dates reflected in column width. For example a date range of 1/1/00 - 12/31/01 and 1/1/02 - 6/31/02 would be proportioned according to the length of time the price was at a certain level. Any ideas?
 

Some videos you may like

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

Watch MrExcel Video

Forum statistics

Threads
1,109,549
Messages
5,529,466
Members
409,883
Latest member
asharris90
Top