Excel Charts

[AshJoshi]

Hi,
I have an excel workbook which contains about 15 worksheets. Each worksheet has charts in it, which are plotted based on tables in the same sheet, which grow each week. The charts need to be plotted based on those tables. I created 2 names for 2 columns in one chart and based the chart on those 2 names. If I had to do this for each work sheet,what would the best option be? Should I be creating names in each worksheet to plot the chart or is there a better way? Also is there a limitation to the number of names I can create as I have 4 charts in each sheet. Anyone with ideas??

[shg]

Welcome to the forum.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.