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.
Bookmarks