Perfect!
Thanks for your quick response.
Kind regards,
Ben
Search found 7 matches
- Fri Sep 07, 2012 9:43 am
- Forum: ActiveX
- Topic: Bar Charts & X Axis
- Replies: 2
- Views: 5864
- Thu Sep 06, 2012 3:27 pm
- Forum: ActiveX
- Topic: Bar Charts & X Axis
- Replies: 2
- Views: 5864
Bar Charts & X Axis
Hi there everyone, Probably doing something really stupid (hopefully...) but I have a database table which I am trying to display in a Bar Chart. Data similar to as follows: PUPILID PUPILNAME VALUE 1 Ben 15 2 Rob 17 3 Geoff 12 4 Wendy 16 5 Jenny 15 The idea is that VALUE would appear on the Y Axis, ...
- Thu Jul 19, 2012 8:39 am
- Forum: ActiveX
- Topic: Change of Recordsource stops the Smoothed line
- Replies: 9
- Views: 14321
Re: Change of Recordsource stops the Smoothed line
Brilliant.
Thanks ever so much for your help Yeray. All working and all sorted!
Thanks ever so much for your help Yeray. All working and all sorted!
- Wed Jul 18, 2012 9:13 am
- Forum: ActiveX
- Topic: Change of Recordsource stops the Smoothed line
- Replies: 9
- Views: 14321
Re: Change of Recordsource stops the Smoothed line
Yeray, Thanks for your assistance. I have successfully managed to keep my lines smooth! However, and this is tempermental in the test project I am uploading so I hope you are able to replicate at your end (but does it all the time in my live project), Bottom axis resets, so it no longer appears as a...
- Mon Jul 16, 2012 3:50 pm
- Forum: ActiveX
- Topic: Change of Recordsource stops the Smoothed line
- Replies: 9
- Views: 14321
Re: Change of Recordsource stops the Smoothed line
Apologies for that. I have removed the formatting of the dtDate and have advanced the dates within the data so it should successfully work (there was no error here so I can only assume this was the issue)
Kind regards,
Ben
Kind regards,
Ben
- Mon Jul 16, 2012 1:03 pm
- Forum: ActiveX
- Topic: Change of Recordsource stops the Smoothed line
- Replies: 9
- Views: 14321
Re: Change of Recordsource stops the Smoothed line
Thank you for the reply. I have included an example project which displays a smoothed line when the project is first loaded, but a change of date reloads the line and removes the smoothness. I would be thinking that as the line has been dictated as smooth, it should stay as such (unless I have unkno...
- Thu Jul 05, 2012 2:45 pm
- Forum: ActiveX
- Topic: Change of Recordsource stops the Smoothed line
- Replies: 9
- Views: 14321
Change of Recordsource stops the Smoothed line
I have a screen whereby the user selects a date, which creates a new recordset (from Access) grabbing only the records with the specified date. When this recordset is passed to the Series Line for a second time and any time after that, the Series line is no longer Smoothed. Here is the code to setup...