If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
chart with changing data source interactive chart
Hello,
I'm trying to make a chart from a pivot table, but only from certain colunms within that table. Therefore I made a second table next to it that just equals the pivottable. From that second table, I made the charts I wanted. If I change the pivottable, the second table changes equally, as does the chart. So far so good. The problem is when the pivottable becomes shorter if due to a selection in the variables because there are less results to show. These changes results in a second table from which the last rows have no values and the chart which does not adapt itself to the changing data source and thus giving the last values to be zero. How can I make the data source of a chart to be interactive with the changes in the pivottable? Or how can I make sure that the data source of a chart changes with a data source wich has grown or diminished? I would very much appriciate any help. Thanks, Feketik |
Thread Tools | |
Display Modes | |
|
|