Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Line Chart Macro
I want to write a macro that will make a line chart out of the trends w pull from our SCADA system at work. I want this macro to be able t work on any trend I pull. In another words, I want it to be able t chart 1, 2, 3, or any amount of columns past column C with varyin amount of rows. The rows will depend on the amount of data points in m trend. C1 is a blank cell and the rest of the C column will be time and dat of the data points in the other columns to the right. Data in column will be the x category axis in all of the charts. I tried to record a macro with the recorder to see what the code woul look like. The problem with this is that the finished macro will onl work with the file I used to record it with. It defines the absoulut range of the data in the file. How can I change this range reference to pick all of the data and row right and below cell C1? Regardless of the amount of data that is i the file. Of course I do not want it to define a range over empt cells. Are there any programers out there that want to give me a clue ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Line Chart - Chart line to go directly to next value | Charts and Charting in Excel | |||
Macro to change position of chart labels on line chart | Charts and Charting in Excel | |||
How do I convert a line chart to a vertical line chart in Excel | Charts and Charting in Excel | |||
Macro commands to assign colors to each line in an Excel chart. | Charts and Charting in Excel | |||
macro for fixed color lines in line chart based on series name | Charts and Charting in Excel |