Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Charting Question
I don't know if the use of a chart within Microsoft Access should be
discussed here or in the access thread - i know that Access uses the Excel Charting object (or i think it does)... I have a graph that i'm trying to display showing the history of a few fields. There are 2 tables: Person and PersonHistory... For each person there is 1..many records in person history... So the chart would show the trend of these fields in PersonHistory over time (week_ID is one of the records in personhistory...) I am putting the chart on form that will enable the person to select a person from a dropdown containing all of the rows in the person table... Also on this form is a check box for each statistic that would let the user determine what to show on the graph (it defaults to having all show up)... 1) I have it working now that as you change what's visible in that dropdown the data in the subform containing the chart changes, which is visible if i put the chart on in datasheet view. However, when it's in the chart view, as i scroll thru the records ti shows a blank chart unless the first person is selected. How do i make the chart get refreshed based on underlyind data??? 2) How would i change the lines on the chart that were visible? 3) The legend is showing "sum of <stat 1" "sum of <stat2" etc instead of having the label just be "stat1", "stat2" etc... I put the fields in there by dragging and dropping from the field list into the main box... Is there a way to edit the legend values (i thoguht there was in excel, but don't see how to get there). Thanks so much, this is my first foray into the land of charts. -Ben |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Easy charting question (hopefully) | Charts and Charting in Excel | |||
vba charting question | Charts and Charting in Excel | |||
quick charting question for similar charts on multiple sheets | Charts and Charting in Excel | |||
Dynamic Charting Question | Charts and Charting in Excel | |||
Simple charting question | Charts and Charting in Excel |