How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask NewITZone Your Own Question

NewITZone
NewITZone, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 90
Experience:  I have been using Office Pro for 10 years and implemented applications for business use.
53509759
Type Your Microsoft Office Question Here...
NewITZone is online now
A new question is answered every 9 seconds

I have created a stogram using the Excel Data Analysis pak.

Customer Question

I have created a histogram using the Excel Data Analysis pak. As new values become available, I want to edit the input data so that the changes can be reflected in the histogram. Is this possible without creating a whole new histogram?
Submitted: 6 months ago.
Category: Microsoft Office
Expert:  Bhavik Joshi replied 6 months ago.

Hi Welcome to JustAnswer.

Yes, It possible to do it. Please try and edit it , you should see a change in your histogram.

Let me know if you face any problem in it.

Customer: replied 6 months ago.
I have tried to edit it, but I have had no success. It only edts the bins and the frequency, not the input data which is what I need to edit to keep the histogram currrent
Expert:  Bhavik Joshi replied 6 months ago.

Can you please attache your excel here . I will see why it is not updating it.