Need code written or excel magic so graphs generated from data will change with date input

  • Status: Closed
  • Premie: $50
  • Mottatte bidrag: 2
  • Vinner: lherreraz

Konkurransesammendrag

Have an excel sheet with graphs currently set up pulling information from tables. The weekly graphs need to be set up so they automatically show the last 12 weeks of data (12 weeks back from the the date input) and the monthly graphs need to be set up so they automatically update to show the last 12 months of data based on the date input.

There needs to be a way to enter the date so that the graphs know were to work back from? Maybe a pop up textbox in vba asking for the date? or a box in excel where the date is entered?

Feel free to change the graphs and tables as need be to any format or setup to make this possible. The easier the sheet is to use the more likely it will be to win.

Will need to see a video or some evidence of the graphs working with changing date to award this prize.

If this an exceptionally hard task or requires significant work please let me know

Anbefalte ferdigheter

Arbeidsgivers tilbakemelding

“Awesome work”

Profilbilde lilipots, Australia.

Beste bidrag i denne konkurransen

Se flere innlegg

Offentlig avklaringstavle

Ingen meldinger enda.

Hvordan å komme i gang med konkurranser

  • Legg ut din konkurransen

    Legg ut din konkurranse Raskt og enkelt

  • Få mange bidrag

    Få mange bidrag Fra hele verden

  • Kår det beste bidraget

    Kår det beste bidraget Last ned filene - Enkelt!

Legg ut en konkurranse nå eller bli med i dag!