Charting

[Pearl]

I don't know how to work with SQL codes but can and have used the DESIGN
features in ACCESS to create forms and other simple charts. I need to
create a STACKED "monthly" bar graphs that will outline Total hours for all
the events that month and within that bar, separate each of the different
events to correspond to the hours for that event. So, if I have 3 events
(event 1, event2 and event3) and EVENT 1 was 5hrs and EVENT 2 was 3hrs and
EVENT6hrs, the single bar for the month will have a total value of 14hrs and
inside the bar will have 3 divisions. One division would be Event 1
(corresponding hrs of 5) , another would be Event 2 (corresponding hrs of 3)
and Event 3 (corresponding hrs of 6).

How can I do that without coding?

Thanks

 

[strive4peace]

Hi Peal,

make a new form -- use the wizard and choose Chart Wizard. Make a
column chart with any table or query (we are going to change what it is
based on so don't worry what kind of chart you make -- we just need the
form with the chart object

Then, go into the design view of the form

turn on the Properties
(right-click anywhere and choose Properties from the shortcut menu)

select the form itself
(Ctrl-R
OR
click in the upper-left corner where the rulers intersect)

on the Data tab of the Property Sheet,
replace the form RecordSource with this:

SELECT [Mo], Event1, Event2, Event3 FROM [ChartData];

Where
Mo is the name of your month field
ChartData is the name of the table or query with the information

then, double-click on the chart -- the border will change to parallel
angle lines

right-click somewhere on the chart and, from the shortcut menu, choose
--> Chart Type...

Pick --> Column
from the Chart Type on the left

Pick --> Stacked column
from the chart sub-type on the right

click OK

click outside the chart area on a gray part of the form to de-select it

save your form

now look at the form view -- voila! you should have a stacked column chart!


Warm Regards,
Crystal
remote programming and training

Video Tutorials on YouTube!
http://www.youtube.com/user/LearnAccessByCrystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
have an awesome day
*

 

[Pearl]

Thanks
I got the chart created

Hi Peal,

make a new form -- use the wizard and choose Chart Wizard. Make a
column chart with any table or query (we are going to change what it is
based on so don't worry what kind of chart you make -- we just need the
form with the chart object

Then, go into the design view of the form

turn on the Properties
(right-click anywhere and choose Properties from the shortcut menu)

select the form itself
(Ctrl-R
OR
click in the upper-left corner where the rulers intersect)

on the Data tab of the Property Sheet,
replace the form RecordSource with this:

SELECT [Mo], Event1, Event2, Event3 FROM [ChartData];

Where
Mo is the name of your month field
ChartData is the name of the table or query with the information

then, double-click on the chart -- the border will change to parallel
angle lines

right-click somewhere on the chart and, from the shortcut menu, choose
--> Chart Type...

Pick --> Column
from the Chart Type on the left

Pick --> Stacked column
from the chart sub-type on the right

click OK

click outside the chart area on a gray part of the form to de-select it

save your form

now look at the form view -- voila! you should have a stacked column chart!


Warm Regards,
Crystal
remote programming and training

Video Tutorials on YouTube!
http://www.youtube.com/user/LearnAccessByCrystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
have an awesome day
*

I don't know how to work with SQL codes but can and have used the DESIGN
features in ACCESS to create forms and other simple charts. I need to
create a STACKED "monthly" bar graphs that will outline Total hours for all
the events that month and within that bar, separate each of the different
events to correspond to the hours for that event. So, if I have 3 events
(event 1, event2 and event3) and EVENT 1 was 5hrs and EVENT 2 was 3hrs and
EVENT6hrs, the single bar for the month will have a total value of 14hrs and
inside the bar will have 3 divisions. One division would be Event 1
(corresponding hrs of 5) , another would be Event 2 (corresponding hrs of 3)
and Event 3 (corresponding hrs of 6).

How can I do that without coding?

Thanks