[FONT='Verdana','sans-serif'][FONT='Verdana','sans-serif']I have a workbook that I enter data (time study times) into one worksheet, and then the workbook takes that data and creates two charts in another work sheet. Its suppose to create a pie chart by category and a staked bar chart by process time and step.
The issue I'm having is that I need to enter at least 3 times the amount of lines on the first data collection sheet, but when I do that I lose the code, formulas etc. and my charts do not work properly on the next worksheet. [/FONT]
[FONT='Verdana','sans-serif']I have tried every way possible to enter new lines but it will not work without disabling the staked bar chart.[/FONT]
[FONT='Verdana','sans-serif']I have tried to rebuild it line by line but I still have issues.. Any help adding rows that will still chart is greatly appreciated![/FONT]
[FONT='Verdana','sans-serif']Please see attachment[/FONT]
Thank you for your help.
Jerry
[/FONT]
Reply With Quote