I have a report that I have built that pulls in data from a popular CRM solution called Smart Focus. The report is able to generate powerful insight when displaying email campaign results in charts.
The report opens and asks you to select a campaign and hit a refresh button, at which point it goes and fetches the data from smart focus via a tool called smart reporter.
The only issue I have is on the creation of a particluar chart for the report. Our campaigns are made up of multiple segments and each email that is sent could have varying numbers of links for the user to click.
Excel will not allow me to create a chart that accomodates the dynamic nature of my data.
I need to be able to automate a chart that shows link clicks by segment where the number of segments and the number of links changes.
Does anyone know a way for creating a VBA macro to accomodate this?
The report opens and asks you to select a campaign and hit a refresh button, at which point it goes and fetches the data from smart focus via a tool called smart reporter.
The only issue I have is on the creation of a particluar chart for the report. Our campaigns are made up of multiple segments and each email that is sent could have varying numbers of links for the user to click.
Excel will not allow me to create a chart that accomodates the dynamic nature of my data.
I need to be able to automate a chart that shows link clicks by segment where the number of segments and the number of links changes.
Does anyone know a way for creating a VBA macro to accomodate this?
