Dataview not updating
You can then click on ‘Add’ to add additional series. The resulting chart, in my case, produces a chart like the one below.
Once your server is started, you will see the default template as your visual. This can be useful if we release a fix for a past API version or if you want to update to the latest API version.
If we release an update to an existing API you can get the latest version by doing the following.
You have your data in rows, each row being a month with the first row being the labels for the columns of data.
You add a cell that’ll be used to determine how many months (rows) of data will be graphed. The worksheet is called ‘Data’; The cht Cats is were all of the work is done.
It is then used to define all of the names ranges that you’ll use to generate the charts that you want, in my case; When you go to create a chart, in Excel 2007, just use the wizard initially.
It also launches an https server that will serve your visual for testing in your favorite web browser.To view your visual, go to your desired report and add the debug visual.
Now; You should now have the first series on a chart.It turns out that creating dynamically updating charts isn’t quite as simple as I thought it would be.You do use Excel Named Ranges but in a whole lot more complex way than I thought you would.will overwrite the version in your visual with the latest version.This will maintain the api version your visual already uses (specified in your file).You can now add additional series to the chart by right clicking in the chart area and selecting ‘Select Data…’ from the drop down.