If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Automated task to present data in a graph form.
Hi, I am newbie to Excel area. I got a requirement where in I need to present the Excel sheet data with 3 columns in a graphical form. Everyday, the excel sheet is populated with the current data. This is automated from the backend. I want to know whether there is any possibility of a macro which draws a graph with the data present in the excel sheet. It should be an automated task. Thanks for the help in advance. -- luckyguy ------------------------------------------------------------------------ luckyguy's Profile: http://www.excelforum.com/member.php...o&userid=28503 View this thread: http://www.excelforum.com/showthread...hreadid=481002 |
#2
|
|||
|
|||
Automated task to present data in a graph form.
You probably don't need a macro. Make a workbook with dummy data that's
arranged the way your incoming data is arranged. Make a chart from this data. Now just have the incoming data populate the range that initially contained the dummy data. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ luckyguy wrote: Hi, I am newbie to Excel area. I got a requirement where in I need to present the Excel sheet data with 3 columns in a graphical form. Everyday, the excel sheet is populated with the current data. This is automated from the backend. I want to know whether there is any possibility of a macro which draws a graph with the data present in the excel sheet. It should be an automated task. Thanks for the help in advance. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Combo Box NotInList - How To Add Data To Underlying Table | 10SNUT | Using Forms | 19 | July 8th, 2005 09:12 PM |
strategy for data entry in multiple tables | LAF | Using Forms | 18 | April 25th, 2005 04:04 AM |
Requerying a pop up form to display in the main form | Jennifer P | Using Forms | 13 | April 5th, 2005 06:59 PM |
Format on data to import to Access tables? (I need your advice) | Niklas Östergren | General Discussion | 5 | December 13th, 2004 02:54 PM |
Dates in a listbox connected to a form... | RusCat | Using Forms | 13 | November 25th, 2004 02:31 AM |