We have an Excel spreadsheet with numerous 3-D chart objects, mostly the 21st Century pie chart but also other bar charts. I need to embed those objects into an Access report but the shadows show up as dots and lines are jagged. I found that linking the charts to a Word doc first, then embedding them into the Access report works best with little distortion. I need this automated but can't figure out how.
1) Is there a way to use the 21st Century pie chart in Access so I can avoid all those steps?
3) If not, can you give me an idea of the code to use to automate the move from Word to the Access report?
Thanks!
1) Is there a way to use the 21st Century pie chart in Access so I can avoid all those steps?
3) If not, can you give me an idea of the code to use to automate the move from Word to the Access report?
Thanks!