Conditional Formating Problem

[Francis Ogwal]

Hi everyone, this is Francis Ogwal, I made a population Pyramid using Conditional formatting Data Bar with City in the middle, Number of Males on the right and females on the left, i want to copy it and paste it into word to write a report but the bars are not being shown unless i link it has a picture and then copy, how can i copy and paste it into word without linking it as a picture and the bars also get copied. THANKS YOU.