Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Graphing Variable-length columns
Hi, I have a situation where I have a spreadsheet with 2 columns, A and B.
Column A is the date and Column B is the # of bids we have submitted on that day. I create a graph based on those columns, that shows the date on the X-axis and the # on the Y-axis. But I would like the graph to be updated automatically everytime I add a new row to the spreadsheet. So that tomorrow, when I add the row for May 10, the chart will reflect May 10 without requiring me to recreate the chart. Is this possible? I've tried everything I can think of and it hasn't worked. Thanks! Ben |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
filtering unique in multiple columns | Excel Worksheet Functions | |||
Hidden Columns in Shared Workbooks | Excel Discussion (Misc queries) | |||
Excel 2003: In a Macro,how to select a variable row length table | Excel Discussion (Misc queries) | |||
Graph with variable data length | Excel Discussion (Misc queries) | |||
Sum a column of variable length? | Excel Discussion (Misc queries) |