Charting in Access

[NISMOJim]

What is the best way to add a column chart (MSGraph.Chart.8) to a report. I have tried adding it directly to the report, but have been told it is best to build it as a form, then somehow add that to the report. Is there a difference between the two?
The problem I am having is with the way the column chart displays. In design view, I formatted 4 of the data series as a stacked column chart, each set up with its own color, and a fifth data series as a line chart on the same axis. When I change to print preview, the second data series (column) turns into the line chart, & vice versa. I tried cutting & pasting the columns how I want them in the little Excel spreadsheet thing that pops up with the chart in edit mode,(and just what is Expr1002 in the upper left corner?), but it keeps changing back. How can I permanently set these colors and chart types so they stay the same regardless of the data being displayed? When doing charts in Excel, I would occasionally stumble on an order preference, but I can't seem to find it here. That may be the root of my problem, but I'm still not sure why the chart types are changing on me.

I am fairly new to charting in Access, so the more descriptive, the better. Thank you for any and all help.

[apr pillai]

Plot the Line series value into the Secondary Y Axis.