VBA Line Chart

[Meruem]

Hello guys,

I am trying to graph a LINE chart in Excel 2013 by VBA. So, here is a data I am trying to graph:

Months Passed 1 2 3 4 5
01/01/2014 2% 3% 5% 7% 10%
02/01/2014 1% 4% 6% 19% 0
03/01/2014 20% 21% 21% 0 0
04/01/2014 13% 13% 0 0 0
05/01/2014 7% 0 0 0 0

I could not paste this data properly, so here is the image of it:

Untitled.png

I am trying to graph a line chart, with X values of 1,2,3,4,5 and Y values of Percentages. My series will be Dates.
Moreover, I want to graph lines without 0 values. For example, Series 2 (02/01/2014) with values of only 1%, 4%, 6% and 19%. Series 3 (03/01/2014) with values 20%, 21%, 21%. To clarify, something like this:

Months Passed 1 2 3 4 5
01/01/2014 2% 3% 5% 7% 10%
02/01/2014 1% 4% 6% 19%
03/01/2014 20% 21% 21%
04/01/2014 13% 13%
05/01/2014 7%

I could not paste this data properly, so here is the image of it:

Untitled1.png

I tried several ways but still can not graph it. Could you please help me?

Thanks in advance.

[MrShorty]

I think a sample file which includes some of those failed attempts would be helpful for us to understand what you want.

I expect that the difficulty is how to "hide" the 0 values in the chart. Have you tried using N/A for those values? I would expect that to work just fine. See this discussion on simulating empty cells in charts: http://peltiertech.com/mind-the-gap-...g-empty-cells/

[Meruem]

Wow, thanks a lot! Now I do not even need a VBA code