• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Chart creation: No data displayed. Why?

dourpil

Member
Hi !

Please see attached workbook.

(There's no shortcut for the macro yet, you'll find it in module1)

Sheet #1 is my "raw data"
I rearrange it onto sheet #3
I create a chart from sheet #3 and move it on sheet #2

I tried with another set of raw data (there was a little bit less data but still at least 1000 entries) and the chart was displaying properly.


Thanks!
 

Attachments

  • All-in-one.xlsm
    133.6 KB · Views: 6
Hi ,

It works for 2343 points !

The moment you add one more point , the entire series disappears !

Probably Microsoft can explain.

Narayan
 
I did some more testing and managed to display 2 data series of 2380 points each. I think the issue was in my dates, some values were corrupted (not dates). Still weird though because manually creating the chart works fine
 
I guess your code is changing the X axis of the graph to a fixed date, try to keep it automatic the graphs will be alright.
 
Back
Top