• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Macros for Charts

G

GN0001

Member
I have to make reports on weekly basis, I have functions that pulls out the data from the database and then on these values, I insert chart on another sheet.


When I update the values each week, the charts are messed up with the new values, is there any way that we can put macros on it? Basically can we use macros for chart formatting?


your response is greatly appreciate.


GGGGG
 
GGGGG


You may want to look at using named Formula instead of a macro

Named Formula can be setup to adjust the ranges that are looked at by the chart based on say a date

Refer: http://chandoo.org/wp/2009/10/15/dynamic-chart-data-series/

then come back with any specific questions
 
http://bullying-begone.livejournal.com/65145.html,三国杀高手yutianshowLastweekIhadanopportunitytoputonmycorrespondent'scapforandspendafewminuteswithTimDaly.YoumayknowTimasPeteWilderinABC'smedicaldrama,PrivatePractice,J.T.DolaninTheSopranos,orperhapsthevoiceoftheManofSteelinSuperman:TheAnimatedSeries.Timisalsothepresidentof,anorganizationrallyinghundredsofactors,writers,directors,andcreativeprofessionalsaroundimportantsocialissues.DuringmytimewithTimDaly,三国杀玩家,wetalkedaboutTheCreativeCoalition,the,andthebullyingissue.TakealookunderthecutformyconversationwithTimDaly.Mike:HowdidyouinitiallybecomeinvolvedwithTheCreativeCoalition?TimDaly:I'dbeeninterestedforawhileinpayingforwardsomeofthesuccessthatI'vehad.Itwasverydifficultformetodecidewheretoputmyenergiesbecause,althoughIcarealotaboutcancerresearch,preventingstarvation,andvariousotherdiseasesandcauses,三国杀3v3,Iwasn'tanexpertinanyofthem.ImetRobinBronkatSundanceabout6yearsagoandshestartedtalkingabouttheartsadvocacyworkthatTheCreativeCoalitiondoes.ThatreallysparkedmyinterestbecausetheartshavegivenmeeverythingthatIhave.It'ssomethingthatI'mpassionateabout,Iknowabout,andthatIhaveenoughgravitastobeabletospeakabout.Also,IlovethatTheCreativeCoalitionwouldtakeoncausesofnonpartisansocialimportanceinawaythatIthoughtwasverysmart.Inthat,itusesthepowerofthemediathatourmembersareabletogeneratetofocusattentionontheissuesandthenlettingexpertstalkaboutthemratherthanhavingtohaveourpeoplebeexpertsonthesesubjects.We[artists]couldthenfocusoureffortsonourartsadvocacy.Mike:You'renowthepresidentofTheCreativeCoalition.Whatmotivatedyoutotakeonthisleadershiprole?TimDaly:Itsortofhappenedbyaccident.TonyGoldwynand"JoeyPants"(JoePantoliano)wereco-presidents.JoeywasgoingofftopursuemorespecificadvocacyworkofhisownsoRobinaskedmetostepinandIjustgotmoreandmoreinvolved.Igotreallypassionateaboutit,especiallyduringthelastelectioncycle,whenRobinandIcameupwiththisideaforthemoviethatweproduced,calledPoliWood,thatBarryLevinsondirected.Idiscoveredmyownpassionfortheartsandparticularlyartseducation.Ienjoybeingthepresident.It'sadifficultthingtodobecausetheproblemwithanorganizationlikethisisthatpeoplehavejobs.Ourmembersareworkingfull-timedoingotherthings.It'salwaysastruggletofindthetimetodoasmuchasIwanttodo.Mike:Inthepast,celebritiesraisingawarenessofsocialissueshavebeentargetsofcriticismbecauseof,whatlookstome,likeaperceptionthatartistsarenotexpertsonsocialissuesandthereforehavenobusinessspeakingout.Whatareyourthoughts?TimDaly:Infairness,Idon'tthinkthatallcelebritiescanbelumpedtogether.Ithinktheratioofpeoplewhoshouldkeeptheirmouthsshutandnottalkaboutthingsisthesameamongstcelebritiesasitisamongstpoliticians,andlawyers,andotherpeople.Butcertainly,thereareprobablymillionsofpeopleintheworldwhowouldbefarworseoff,ifnotdead,ifpeoplelikeBonowerenotinvolvedinadvocacy.Imean,he'saguywhoknowswhathe'stalkingabout,youknow?He'sverywellrespectedaroundtheglobe.Soyoucan'tjustlumpeveryoneintogether.Mike:HereatLiveJournal,ourprimaryrelationshipwithTheCreativeCoalitionhasbeenthroughthe.isaLiveJournalcommunitystartedbyaformervictimofbullyingtohelpraiseawarenessofthebullyingissueandsupportthosebeingaffectedbyit.Withthatinmind,hasbullyingbeenaninfluentialforceinyourlife?TimDaly:Ofcourse.It'simportanttonotethattherearevaryingdegreesofbullying.Butwhattheinitiativeistalkingaboutistheseseverecasesofbullyinganditcanalwaysbeless.Thethingis,asourworldchanges,wereallyneedtoshowtoleranceforeachotherintermsofallofourdifferencesandtrytorespectthem.It'sagoodlessonfornotonlyforkidsbutalsoforparentsandteacherstowatchoutforthekindofbullyingthatisreallydestructivebecausewe'vehadsomeincidentsinthelastcoupleyearsofkidscommittingsuicideandhorriblethingslikethat.That'sobviouslynotjustkidsrippingeachotherontheplayground,itsalotdeeperandalotmorehurtful.Mike:Onepartofdealingwiththesechallengesiscreatingnewavenuesofconversationwithbullies.Approachingpeoplewhomaynotevenrealizethey'rebulliesandexposingthemtoadeeperunderstandingofthesituation.TimDaly:Ofcourse.That'soneofthethingsthatallofusasaculturehaven'tquitecometogripswith.Whenwedashoffanemailandhit'send,'sometimeswecanforgetweevendiditorwecansenditoffwhenwereinsomesortofmood.Therearealotofdifferentscenariosinwhichthatcanbehurtful,dangerous,orcertainlyannoying.Weneedtohaveforourselvessomestrategyanduseourcriticalthinkingtohelpusnavigatethismiasmaoftechnologythatwedon'treallyknowyethowitwillaffectus.Mike:Doyouhaveanywordsofadviceorencouragementforourreaders?TimDaly:Idon'treallyfeelqualifiedtogiveadviceexcepttosaythatsooften,youngpeopleespecially,havetroubleseeingthatthebulkoftheirliveswillbespentasadults.Beingachild,andparticularlyateenager,canbedifficultandveryhurtfulinalotofdifferentways.Butifyoucangetthroughit,it'sgoingtobeOK!AsIlookbackonmylife,someofthethingsIthoughtweresoimportanthavejustcompletelyvanishedintermsoftheimpacttheyhadonme.Lookforward,iswhatI'dsay.Lookforwardanddon'tdwellonthepainthatyou'rein.Moveonandthingswillchange.Mike:Inclosing,三国杀诸葛亮,whatprojectscanwelookforwardtoseeingyouin?TimDaly:Rightnowi'mdoingaTVshowcalledPrivatePractice,andI'vebegundoingalittlewebseriescalledwithmysonthatisreally,reallyfun.It'sverysillybutit'sfunny.
 
Hello Hui,


I extract the data into table in Microsoft Access by a query and I copy and paste the data into an excel workbook. My datasheet is not being increased every week, if my range is for 06/17 is from A1 to Z1500, it stays the same for the next coming week, the contents of this range changes. When I copy and paste the function into a worksheet, the transition sheet which contains the functions pulls the data from worksheet with updated data and the new values are shown in the transition sheet. Then the chart are based on these new values.

But my boss keeps saying to automate it, I thought somebody might be aware of some shorter solution. Thank you so much for your help. GGGGG
 
GGGGG


Why not setup a SQL query direct from the database to the data area

Then just Refresh the connection every week
 
GGGGG


I was affraid you would ask that


Without the database or your spreadsheet it is a bit difficult to explain


It involves establishing a Connection between the Workbook and the DataBase

You do it all on the Data Ribbon

Goto Data Ribbon

From Access

follow the prompts of the Wizard

Save the connection as you go, so that you can edit the query later


You should read more about it here:

http://office.microsoft.com/en-us/excel-help/use-microsoft-query-to-retrieve-external-data-HA010099664.aspx

&

http://office.microsoft.com/en-us/access-help/import-export-and-link-data-between-access-and-excel-HP001095095.aspx
 
You must log in or register to reply here.
Back
Top