PDA

View Full Version : Complicated Charting Issue



jkittle1122
01-23-2013, 01:54 PM
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.
I have tried every way possible to enter new lines but it will not work without disabling the staked bar chart.
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!
Please see attachment
Thank you for your help.
Jerry