Hi Guys, I have got a problem with a macro that put few lines from a sheet to a chart.
First I have tried to use autofilter to arrange the necessary data together and created the chart on that area. Unfortunately this idea was good enough because when I released the autofilter out the whole chart source area became stretched. So I have tried the place the data line by line onto the chart, so wrote a procedure that does this task. It just used a conditional statement and collected the appropriate lines for the date source field. At the end the Excel dropped an error message as the created formula is too long - however previously I have placed the same amount of data and did not give me any error message. I'm wondering whether the data source refreshing might be turned off on a certain chart and this way I could use my original idea with the autofilter. I do not like to disable the chart refreshing in the workbook as I need use this feature on other sheets. Please let me know if you have any idea how to solve the problem? Thanks in advance. --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
