In Excel, How can I make the graph change by adding or taking away data? When I do, it doesn't update graph?
-
I added future weeks into my data. However, my boss doesn't want it that way...he says it looks like we are low in production. So, each week I have to do a WHOLE NEW graph for the new week. Isn't there an easier way? Because when I subtract the weeks I don't want from the data, it doesn't update the graphs, and on the graphs, it won't allow me to just delete the weeks. I use both kind of graphs with one data....I use a line graph and I also use a bar graph. Thanks
-
Answer:
This solution autoupdate the chart as you enter the data in the table, since you didn't mention the details of the columns, i made up a 3 columns table for the automation Here's the solution to your problem http://www.freewebs.com/swhtam/YA/autoUpdateChart.xls Inside the file there will be notes on the solution, Please contact for more info
froggieg... at Yahoo! Answers Visit the source
Related Q & A:
- How do I change the display name that people see as my name when I send a yahoo email?Best solution by Yahoo! Answers
- How can I make clay use to make things?Best solution by Yahoo! Answers
- How can I make my room look amazing when I clean it?Best solution by Yahoo! Answers
- How can I make this career change - Marketing/Admin to Fine Arts?Best solution by Yahoo! Answers
- How can I make nausea go away?Best solution by wikihow.com
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.