chart 2007 2010

Hello, I've been trying to get a line chart to hide 0 values. I've tried forcing the formulae to make a blank cell and for a NA() but the chart still connects 0 values.- (Please see video link below) Any help on how to solve this would be hugely appreciated...

I am trying to use Excel VBA to import data into my active workbook and then use two combo boxes(which should get populated once the data is imported) drop down menu's to make a selection of any two variables from the data and create a choice of chart(Line, Scatter etc). I have already done the...

I am working with Excel 2007 in a Dutch version, so applogise if a possible translation would confuse you. Looking to use vba applying a different weight to a chart line and the markerborder. Seems that the two are always connected, eg With activechart.seriescollection(1)...

Hi all, am new to this forum so exuse me if I havent provided enough detail but this is all I have! I have an interviw after 7 years of being work on maternity leave ;-) :eeek:and my excel is not what it used to be but have been practising with the help of MR Excel!! :)The following is what i...

My chart axis includes dates from 8/1/12 to current, right to left. My data is chartiing for all dates, but it is not aligned with the dates on the axis; i.e. my data for 8/1 is aligned to the 8/22 date. I have checked and rechecked all the data references, and all seem to be ok. Any ideas?

Does anybody knows how to create a Line Chart with Conditional Formatting? I want to format the line as red if it is off the target and green if it is better than the target. Thanks!

Hi can you tell me why the following lines of code return an error on 2007 & 2010 ? it works fine on 2003. 1) ActiveChart.ChartTitle.Text = Ctitle 2) ActiveChart.SeriesCollection(2).ErrorBar Direction:=xlY, Include:=xlBoth, _ Type:=xlCustom, Amount:=rngINC...