Home |
Search |
Today's Posts |
|
#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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why is the order of my data table opposite from graph? | Charts and Charting in Excel | |||
How do I automatically update a graph after adding a data point | Charts and Charting in Excel | |||
data entry form Excel | Excel Discussion (Misc queries) | |||
Help making a chart that doesn't graph cells without data? | Excel Discussion (Misc queries) | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |