We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message
Contact Forum Editor

Send an email to our Forum Editor:


PLEASE NOTE: Your name is used only to let the Forum Editor know who sent the message. Both your name and email address will not be used for any other purpose.

Tech Helproom


It's free to register, to post a question or to start / join a discussion


 

Excel - updating a chart


Diemmess
Resolved

Likes # 0

This must be fundamental stuff for those who use Excel. Is it possible to have a simple chart update itself automatically as data is added?

I haven't found a way to do this and the idea is more for my amusement than business.

The worksheet contains date, daily totals, and a third column showing the weekly total from the last 7 days.

All I can do to update, is to delete the old chart and build a new one from the growing number of entries in the worksheet. (I'm struggling with Excel 2007).

Like this post
AroundAgain

Likes # 0

Hi

I use Excel 2003 but, in this, I would have thought it should be the same.

Assuming you have formulae in a cell, when you amend the cell with the data in, then click Enter, or move from that cell, the cell with the formula in should then show the new figure.

So, not meaning to teach you to suck eggs etc, cell C1 has date, cell C2 has quantity, Cell C3 has formula. When you update C2, and press Enter, cell C3 should then display the new total.

If you want to update on a new line, then you can drag the formula from cell C3 to C4 (right bottom corner, and get a cross, then click and drag down). This will allow you to enter data in cells D1 and D2, and D3 should display the calculation.

Maybe I've misunderstood what you mean, though. If so, perhaps you could explain further, and I, or someone will try to help.

Cheers

Like this post
AroundAgain

Likes # 0

PS Apologies if you already know all this Cheers

Like this post  
Woolwell

Likes # 0

I think this is what you want Update data in existing chart

Like this post
VoG II

Likes # 0

Like this post
Diemmess

Likes # 0

Phew!

As ever, it is easy when you know how!

I'm sure you have collectively provided the answer with this wealth of information, but I'll leave the green tick until I am happy with a method. No time to meddle until this evening at best.

Thank you for each and every response.

Like this post

Reply to this topic

This thread has been locked.



IDG UK Sites

45 Best Android games: top Android games for your smartphone or tablet in 2014 (24 are free!)

IDG UK Sites

How Apple, Adobe, Microsoft and others have let us down over UltraHD and hiDPI screens

IDG UK Sites

Do you have the X-Factor too? Mix Off app puts fans in the frame

IDG UK Sites

iPad Pro release date, rumours and leaked images - 12.9 screen 'coming in 2015'