Excel Date Driven Charting

I have an excel chart with a list of contracts with start dates and end dates. I have manually created a gannt chart showing the life of the contracts, but want to automate it so that all i have to do is change the end date of contracts and the gannt chart automatically updates. In addition, I need to be able to add and remove contracts as they complete and new ones are won. I also want the start date shown in the gannt chart to be the current calendar quarter and change automatically so that the gannt chart shown today will be different in six months if the data doesn't change. I have attached my manual spreadsheet.

Taidot: tiedonsyöttö, tietojenkäsittely, Excel, Visual Basic

Näytä lisää: date driven gannt chart excel, date driven chart excel, excel automate, data driven, excelchart, 2013 excel visual basic, excel 2013 visual, visual basic six, quarter excel, visual basic excel 2013, excel 2013 visual basic, excel driven, excel start today, automate excel spreadsheet, excel visual basic calendar, end dates, excel genius current ongoing contractor, need excel import current sports scores, excel chart add, excel calendar, visual chart, excel visual calendar, excel automate add, add calendar visual basic, change date

Tietoa työnantajasta:
( 1 arvostelu ) Huntsville, United States

Projektin tunnus: #4248082

Myönnetty käyttäjälle:


I am an excel developer. I am expert in Excel both excel standard and Vba coding. I work with excel more than 10 years. I send you sample file, please check if this is what you want.

$35 USD 1 päivässä
(14 Arvostelua)

7 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Lets do it....I am VBA expert with great experience and can provide solution very fast.

$40 USD 1 päivässä
(67 arvostelua)

Hello Sir, Excel VBA expert here, I have just completed a Dynamic Gantt chart project, plz check my profile to check it out, also chk PM for DEMO of that. Regards.

$35 USD 1 päivässä
(8 arvostelua)

Hi please check PM

$40 USD 1 päivässä
(4 arvostelua)

Hi, Excel/VBA expert here. Please check your PMB for more details.

$50 USD 1 päivässä
(5 arvostelua)

The creation of a working chart would be no issue for me. The only area I am not certain I could complete would be moving the quarters around as the revolve through the calendar year, but I can normally figure those t Lisää

$30 USD 2 päivässä
(0 arvostelua)

Dear Sir, I am interested in your project.I am excel/vba expert. Please check message.

$50 USD 20 päivässä
(0 arvostelua)