Search results

That's exactly what I want. Thanks Narayan. btw..sorry for late reply I've been away.

No probs Narayan , do it at your leisure.

Hi Narayan, is it possible to change the chart you uploaded to a Stacked Bar or column with an additional column "durationsec".could you change the code please ? ] example chart of what I mean is here. http://dl.dropbox.com/u/36755932/example%20chart.xls thanks james

I cant thank you enough Narayan , you are a legend.

@Narayan , I don't know if you've had time to check my last post yet ;-) Thanks James.

Hi Narayan , thanks for the feedback. sorry I made a mistake in my post . what i wanted to plot is column A(program) against column F(STARTTIME). I tried to hide columns like you did , but it isn't working for me. Thanks James.

I have to amend a chart using VBA to plot column A(program) against column C(Date), at the moment it is mapped as column A(program) against column B(startsec). the piece of VBA code that charts can be seen here Sub createprocesscharts() Dim sets(2, 365) As Long Dim limits(2, 365) As Long Dim...

Great thanks Narayan , you are a legend!

Hi Narayan , I will like to try the "reduce the font size , from 10 to 8 , and make it BOLD" you suggested . I have this as the code to do it ActiveChart.Axes(xlCategory).AxisTitle.Font.FontStyle = "Bold" ActiveChart.Axes(xlCategory).AxisTitle.Font.Size = 8 is this correct ? where do...

Hi Narayan , Thanks the line of code you suggested did the trick!. I can see all the jobs in the new chart, it looks a bit untidy though ;-) is there any way to increase the chart area in order to make the labels tidier ? new chart is here http://dl.dropbox.com/u/36755932/new_chart.xls...

Thanks very much Hui, I have uploaded a sample file -link below http://dl.dropbox.com/u/36755932/request_id.10-Oct-2012-10-01-53.log.csv.180000.220000.xls

Hi , I am a beginner in VBA but I need to amend a VBA code from an old colleague The purpose of the code is to 1) create a chart of all elements on the vertical axis) against a 24 hour time represented in seconds on the horizontal axis. the problem is that 1) the chart get created ,but not...