Ignore the orange column, that is raw data input. I want to create a chart that has the second row from H-P as the curves and the date associated to the data to be the X-axis. As you probably see there is very little data within the chart. How can I create a chart that will automatically add data that I enter into the blue and green columns. Don't worry about any tab but the first.
I changed your green and blue range to an Excel table and built the chart off of it. When you add data to an Excel Chart, pivot tables, formulas and charts "expand" to encompass the new data. Add a new date in Cell I7 and it will show up on the chart.
Also the series names will change when you change the table titles from Col1, Col2, etc. I didn't take the time to track down what these metrics are.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks