How do I create a chart that shows totals and percentages in Word?

[Doug G.]

I'm trying to create a line chart that will shows the percentages as well as
the totals for three different data sets in Word 2003.

Thanks for any suggestions!

Doug

 

[Jezebel]

You say you're trying: what goes wrong?

 

[Doug G.]

I need to set up a second Y axis with the percentages. And ideally, I'd like
to not have to enter the pecentage values and just have them calculated from
the three data sets.

 

[Jezebel]

Do it in Excel then import the chart into Word.

 

[Doug G.]

Alright. I made the worksheet with the data in Excel, with the years in the
columns and the types of crimes in the rows. But I still don't know how to
create the chart I need.