Drawing Simple Line Charts in Access 2007

[afh110]

Hi guys.. simple Q

I have a table that holds the following data and schema

ID Name Jan Feb Mar ......Dec
1 BSC-1 50 78 90 ......79
2 BSC-2 44 43 66 .....65
3 BSC-3 67 88 99 ....66

(Data not important)

I need to create a Line chart plotting the different BSC data over the year (Jan.....to ...Dec). Its more or less a trend analysis of each BSC plotted all together.

If i do it in Excel (Which is extremely easy) i get the attached figure


I can't seem to find a way to get the same plot using Chart Objects or PivotCharts. I really tried all i can think of. Can someone please help out!

Thanks

 

[aqif]

Hi

Create the chart in Access by using the data you want. Then double-click the chart to open chart editor. Click on Data and try "Series in Rows" and "Series in Colums". Sometimes that does the trick.