Column graph problem
in [Reports]
|
From: Jeff on 15 Apr 2010 03:05 Hi, I have a report that displays Global Variables returned from a Public Sub after calculation. It is in a table format and each cell is a TextBox: lblNSD No. lblCS No. lblName1 txtNSD1 txtCS1 lblName1 txtNSD2 txtCS2 lblName3 txtNSD3 txtCS3 lblName4 txtNSD4 txtCS4 The first part has been done and works fine. Now I want to add a column graph (Excel graph) below this table. Can anyone tell me how to feed these variables (value) into the column graph or is there an easier way to do this? Thank you. -- Jeff
From: Duane Hookom on 15 Apr 2010 10:57 Typically you would pull the records from a table or query that would be used in the Row Source property of a chart control. There is some functionality for pushing values into the datasheet of the chart but it is more difficult and rarely used. -- Duane Hookom Microsoft Access MVP "Jeff" wrote: > Hi, > > I have a report that displays Global Variables returned from a Public Sub > after calculation. It is in a table format and each cell is a TextBox: > > lblNSD No. lblCS No. > lblName1 txtNSD1 txtCS1 > lblName1 txtNSD2 txtCS2 > lblName3 txtNSD3 txtCS3 > lblName4 txtNSD4 txtCS4 > > The first part has been done and works fine. Now I want to add a column > graph (Excel graph) below this table. Can anyone tell me how to feed these > variables (value) into the column graph or is there an easier way to do this? > Thank you. > -- > Jeff
From: Jeff on 15 Apr 2010 19:39 HI Duane, Thank you for your response. I know how to build a table with these variables, but can we build a query with these variables? With a table, I have write the variables (table) to the hard disk, then retrieve them from hard disk for the chart. This will slow down the speed of my program. I think I need to learn coding in Excel to get this work. -- Jeff "Duane Hookom" 來函： > Typically you would pull the records from a table or query that would be used > in the Row Source property of a chart control. > > There is some functionality for pushing values into the datasheet of the > chart but it is more difficult and rarely used. > > -- > Duane Hookom > Microsoft Access MVP > > > "Jeff" wrote: > > > Hi, > > > > I have a report that displays Global Variables returned from a Public Sub > > after calculation. It is in a table format and each cell is a TextBox: > > > > lblNSD No. lblCS No. > > lblName1 txtNSD1 txtCS1 > > lblName1 txtNSD2 txtCS2 > > lblName3 txtNSD3 txtCS3 > > lblName4 txtNSD4 txtCS4 > > > > The first part has been done and works fine. Now I want to add a column > > graph (Excel graph) below this table. Can anyone tell me how to feed these > > variables (value) into the column graph or is there an easier way to do this? > > Thank you. > > -- > > Jeff
From: Duane Hookom on 15 Apr 2010 23:49 I think the performance shouldn't take much. I did a quick google search and found this as the first hit http://www.access-programmers.co.uk/forums/showthread.php?t=76241. -- Duane Hookom MS Access MVP "Jeff" <Jeff(a)discussions.microsoft.com> wrote in message news:D0BE801D-8199-40EA-9EFB-E349A6602CB8(a)microsoft.com... > HI Duane, > > Thank you for your response. I know how to build a table with these > variables, but can we build a query with these variables? With a table, I > have write the variables (table) to the hard disk, then retrieve them from > hard disk for the chart. This will slow down the speed of my program. > > I think I need to learn coding in Excel to get this work. > -- > Jeff > > > "Duane Hookom" 來函： > >> Typically you would pull the records from a table or query that would be >> used >> in the Row Source property of a chart control. >> >> There is some functionality for pushing values into the datasheet of the >> chart but it is more difficult and rarely used. >> >> -- >> Duane Hookom >> Microsoft Access MVP >> >> >> "Jeff" wrote: >> >> > Hi, >> > >> > I have a report that displays Global Variables returned from a Public >> > Sub >> > after calculation. It is in a table format and each cell is a TextBox: >> > >> > lblNSD No. lblCS No. >> > lblName1 txtNSD1 txtCS1 >> > lblName1 txtNSD2 txtCS2 >> > lblName3 txtNSD3 txtCS3 >> > lblName4 txtNSD4 txtCS4 >> > >> > The first part has been done and works fine. Now I want to add a column >> > graph (Excel graph) below this table. Can anyone tell me how to feed >> > these >> > variables (value) into the column graph or is there an easier way to do >> > this? >> > Thank you. >> > -- >> > Jeff
From: Jeff on 17 Apr 2010 19:38 Hi Duane, That really helps. Thank you very much. -- Jeff "Duane Hookom" 來函： > I think the performance shouldn't take much. I did a quick google search and > found this as the first hit > http://www.access-programmers.co.uk/forums/showthread.php?t=76241. > > > -- > Duane Hookom > MS Access MVP > > > "Jeff" <Jeff(a)discussions.microsoft.com> wrote in message > news:D0BE801D-8199-40EA-9EFB-E349A6602CB8(a)microsoft.com... > > HI Duane, > > > > Thank you for your response. I know how to build a table with these > > variables, but can we build a query with these variables? With a table, I > > have write the variables (table) to the hard disk, then retrieve them from > > hard disk for the chart. This will slow down the speed of my program. > > > > I think I need to learn coding in Excel to get this work. > > -- > > Jeff > > > > > > "Duane Hookom" 來函： > > > >> Typically you would pull the records from a table or query that would be > >> used > >> in the Row Source property of a chart control. > >> > >> There is some functionality for pushing values into the datasheet of the > >> chart but it is more difficult and rarely used. > >> > >> -- > >> Duane Hookom > >> Microsoft Access MVP > >> > >> > >> "Jeff" wrote: > >> > >> > Hi, > >> > > >> > I have a report that displays Global Variables returned from a Public > >> > Sub > >> > after calculation. It is in a table format and each cell is a TextBox: > >> > > >> > lblNSD No. lblCS No. > >> > lblName1 txtNSD1 txtCS1 > >> > lblName1 txtNSD2 txtCS2 > >> > lblName3 txtNSD3 txtCS3 > >> > lblName4 txtNSD4 txtCS4 > >> > > >> > The first part has been done and works fine. Now I want to add a column > >> > graph (Excel graph) below this table. Can anyone tell me how to feed > >> > these > >> > variables (value) into the column graph or is there an easier way to do > >> > this? > >> > Thank you. > >> > -- > >> > Jeff >
|
Pages: 1 Prev: Grabbing Info from a TextBox on a Report Next: snp viewer |