anyone know a simple config file that will add color to a bar or column3d chart? thanks!

Ah yes, the TO_TIMESTAMP(date,time) function will only work right if both date and time are true date/time objects, not if they are just strings.

I tried that - as follows: logparser "select TO_TIMESTAMP(Date, TIME) as DATETime,Denies into c:\barchart2.gif from c:\denies.txt" -i:TSV -iseparator:space -headerrow N -o:Chart -chartType:ColumnStacked but it always gave me nulls for the date/time output. The chart for this version of the query is attached...

I believe it would be much easier to just use TO_TIMESTAMP(Date, TIME)

Running the following command line LP query against the data you posted (copied directly into notepad and saved as file) C:\>logparser "select TO_Timestamp(ADD(ADD(Date,' '),TIME),'MM/dd/yyyy hx:mm:ss') as DATETime,Denies into c:\barchart.gif from c:\denies.txt" -i:TSV -iseparator:space -headerrow...

OK - I think the answer is that you can't do a forward projection with OWC.xx (Office Web Components) or with the logparser chart output (which seems based on OWC). After inspecting the objects and methods of OWC, I see that the Forward property of the trendline is only available in the Excel object...

I am trying to chart the following data: Date Time Denies 03/01/2007 0:00:00 24 03/01/2007 0:15:00 21 03/01/2007 0:30:00 27 03/01/2007 0:45:00 24 03/01/2007 1:00:00 27 03/01/2007 1:15:00 166 03/01/2007 1:30:00 201 03/01/2007 1:45:00 250 03/01/2007 2:00:00 251 03/01/2007 2:15:00 29 03/01/2007 2:30:00...

found out how to suppress the R squared value: chart.SeriesCollection(1).Trendlines(0).IsDisplayingRSquared = false;

I can get a trendline to appear using Igor's great example code, but cannot get it to project forward by X number of periods. Also, can anyone tell me how to reposition the trendline equation and not have the r squared value display? I've been working on this all day and no luck! Researched MS site but...

Hi all together, the problem is that if you download the file with the MS Internet Explorer I'm not able to open the ZIP file. With Firefox / Mozilla it works. So please try again with a NON MS Browser Greets