Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a chart that is prepared by overlapping 2 different charts as one of the axis is hidden. for the user it appears as a single chart.
is there a way to export this as a single object. I have created macros in the past but they are exported using chart ids. has anyone come across a similar situation earlier?
I have attached chart that user sees.
Total Open -uses a different X axis that is hidden behind
I think it couldn't be done directly. By exporting them into xls/ppt you could use two exports and overlap them there like in qlikview. Another way might be to place (maybe additionally) on a separate sheet or within a report and to it as PDF - I remember to have read anywhere that earlier some PDF printer could be also print the content in a graphic-fileformat, maybe it's an alternatively.
- Marcus
I think it couldn't be done directly. By exporting them into xls/ppt you could use two exports and overlap them there like in qlikview. Another way might be to place (maybe additionally) on a separate sheet or within a report and to it as PDF - I remember to have read anywhere that earlier some PDF printer could be also print the content in a graphic-fileformat, maybe it's an alternatively.
- Marcus
Hi..I think I will need to use 2 exports like in xls/ppt then overlap it and then again convert it into pdf..thanks for your suggestions
Are you exporting the objects to Excel ? If so then keep the object paste in the same cell and try
Activedoument.getsheetboject("CH01").copytocilpboard // Your main object
Objexcel.Rage("A1").select paste
Activedoument.getsheetboject("CH02").copytocilpboard // Your hidden object
Objexcel.Rage("A1").select paste
Hi Marcus
I exported the images into a ppt. then in ppt I have realigned the images and converted the ppt as a jpg.Your perspective was helpful and though I followed a different approach.