Forum Discussion
Create new worksheet with one graph using single cell input from multiple worksheets
GIVEN: - I have an Excel 2003 (don't yell at me!) spreadsheet with multiple worksheets. - Each worksheet has two columns (text label, numeric value) and a graph showing all the columns' values. - ...
I appreciate the suggestions, but, I found them to be overly complicated. I decided to enter the totals by hand into the new worksheet, and then make the graph from that. It turned out perfectly, though I wish I could change the Y-axis values from 100k to 50k (the "format" lets me change it, but, doesn't do anything with it!). Thanks, anyway.
- I did that. Nothing happened in the result, and, when I clicked the Y-axis, again, it showed the original value, as if I had never changed it! I consider the matter closed; 'tis enough, 'twill serve!
If you wish, you could attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar.
