I have a container object with three charts. I need to copy them to a new sheet and in to a new container object. Once copied, I need to change the charts’ expression to display the data needed in the new sheet. I’ve tried cloning but this is not working. I’ve right clicked, clicked clone and then I don’t know what to do. Going to the new sheet and right clicking, paste sheet object is not available.
Any help would be greatly appreciated. I’m using QV 10.
And you're clicking on the tabs for the charts in the container and not on the charts themselves? I only ask because when I try to copy and then paste when I right click on the charts themselves the paste option is not available, however if I click on the container tabs and do the same I am able to copy and paste the entire container.
That doesn't work. I can copy and paste the container object but not an individual chart. I need to get at the individual chart so I can modify the expression. I confirmed that the ‘Allow Copy/Clone’ option is checked in the Layout tab.
When I right click on a chart inside my container and choose Clone is basically makes a copy of that chart without having to paste. I am not sure at this point why that is not working for you. Are you able to post your QVW?
I just noticed that there is a cloned copy of my chart on the sheet I'm working on. It was hard to see becasue it was in the top left corner and minimized. I'm still not able to paste the cloned copy to a new sheet though.