JV, Not sure if I fully understand your question, but here is something that may work. 1. Set up the chart using just the budget data that goes for the whole year., so you will have a single line. 2. For the 2nd line, ighlight the cells that contain all the data up to the current month that you want to include (i.e. to include all data up to now, I assume you will be highlighting jan, feb, mar, apr, may.. 3. Drag and drop the abve highlughted section onto the chart created in 1. if it is a separate worksheet, you may have to cut and paste 4. Repeat steps 2 and 3 for the 3rd line. 5. When you want to update it each month, it should just be a simple matter of dragging and dropping the current cell (i.e. june) onto the chart, and it should update automatically Hope it helps
I went HERE again, after learning that there was no way to push the data I wanted,and found a pretty decent solution. My table creates blanks by using an if/then/else to put in a "" if that month has not yet come to pass. My chart was seeing that formula as not being blank, even though it showed as a blank. By surfing around that help, I discovered that if I used a NA() instead of a "", the chart will count the #N/A it produces as a blank. So, in some hidden columns, I put some formulas like this: =IF(A1="",NA(),A1). I then based my chart on that and it worked like a charm. I guess I was too fixated on pushing the data, I hadn't thought of other ways of masking cells from the chart.
I have another Excel question. I have columns of cells with populated data, numbers then names. I can write some VBA code using the Left function to ignore the numbers that are already in these cells because I just want to pay attention to the names. My question, is there a sort that can be done so that data is sorted by page and not column. Example: Data right now is like this Column A----------Column B----------Column C Doe, Amber--------Doe, Donna-------Doe, Gina Doe, Barbara-------Doe, Eric----------Doe, Hank Doe, Cathy--------Doe, Franklin-------Doe, Isaac When I want to add somebody new to the list I have to do a lot of cutting and pasting but would really like to avoid this. Is there anyway to sort the data completely and just not by column? Let's say I added Doe, Benny to the list under Doe, Isaac. Is there a sort I can do or make that when done will automatically put that name under Doe, Barbara where it needs to go?
My recommendation is to go to that site that pugsly posted earlier. I just posted my problem and someone replied with the vba code to get it done and sure enough it worked. People generally respond pretty quickly and they know what they are doing.
