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.
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.
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.
