Search found 7 matches

by JobyLeigh
Fri Sep 07, 2012 9:43 am
Forum: ActiveX
Topic: Bar Charts & X Axis
Replies: 2
Views: 5901

Re: Bar Charts & X Axis

Perfect!
Thanks for your quick response.

Kind regards,
Ben
by JobyLeigh
Thu Sep 06, 2012 3:27 pm
Forum: ActiveX
Topic: Bar Charts & X Axis
Replies: 2
Views: 5901

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, ...
by JobyLeigh
Thu Jul 19, 2012 8:39 am
Forum: ActiveX
Topic: Change of Recordsource stops the Smoothed line
Replies: 9
Views: 14394

Re: Change of Recordsource stops the Smoothed line

Brilliant.

Thanks ever so much for your help Yeray. All working and all sorted!
by JobyLeigh
Wed Jul 18, 2012 9:13 am
Forum: ActiveX
Topic: Change of Recordsource stops the Smoothed line
Replies: 9
Views: 14394

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...
by JobyLeigh
Mon Jul 16, 2012 3:50 pm
Forum: ActiveX
Topic: Change of Recordsource stops the Smoothed line
Replies: 9
Views: 14394

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
by JobyLeigh
Mon Jul 16, 2012 1:03 pm
Forum: ActiveX
Topic: Change of Recordsource stops the Smoothed line
Replies: 9
Views: 14394

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...
by JobyLeigh
Thu Jul 05, 2012 2:45 pm
Forum: ActiveX
Topic: Change of Recordsource stops the Smoothed line
Replies: 9
Views: 14394

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