Drawing a simple Line Chart

[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.

So Y-Axis should show the names of the BSCs
the X -Axis should show the months of the year
The graph is reflecting the data


I start a Chart Object , close the wizard (since it seems so limited) and i go to the properties table and try to set the source to the table. But im not sure how i can set the the X and Y Axis...
I thought of using a Pivot table, im having the same problem.

Thanks People :)

[OBP]

I use the Chart Wizard for the basic part and then play with in the Form/Chart object.

[afh110]

can you give me more hints on what you mean by playing in the Form/Chart Object? I having a difficult time setting the Axis to be my table column heads! If you can refer me to an example or a link that explains my kind of problem? Bar charts are more straight forward , but i need a line graph..whatever you can give to direct me is much appreciated.:)

[OBP]

Have you looked through the various Chart Options in Chart Edit?
Click on the chart and then Right Click>Edit Chart that give you Chart Type & Chart Options

[afh110]

Im familiar withe Chart options an Types, but i my can't specify anything as i like!

Attached is an image showing how i would like it to look like (I did this using excel which is clear cut to me, but i dont know how to get it in Access)


hope this help u help me :)

[OBP]

Well I would use the Form Wizard to create it as a Column Chart (Default) and the then change the Chart type to Line afterwards.
I know MS Graph is no where near as user friendly or as good as the Excel version, which is a great pity, typical MS though.

[afh110]

I really dont see how doing it in a barchart then converting it to a Line chart this makes a difference. Did you do it and it worked? I just dont know how to make the Chart consider the Data in the JAN-DEC column to be the DATA ! The table im using is very straight forward i think! If you did try it and it worked , please instruct me how.

[OBP]

Sorry I can't upload any more Attachments.
But I have just created a line graph by using and following the Wizard and selecting what I wanted.

[Movian]

Alternatively what i do is export the database to an excel spread sheet through office automation and create the graph on there as part of the automation.