@ElenaSarah
You've had this question up for nearly two weeks and received no replies. I think the difficulty may be that you give us so little to work with, on top of describing yourself as a novice in Excel.
So a bunch of questions for you.
- Have you a histogram producing spreadsheet now?
- Does it work with a representative data set?
- Does it work satisfactorily?
- Do you need to keep a record of all the datasets that you've graphed (for possible future reproduction, for possible comparisons, etc?) OR is a graph once produced "past history" such that you could just write over the data that produced it?
- How does the "raw data" come to you? On paper? In electronic form? If the latter, is it always consistent? Is it in Excel already?
Let's start with those. Depending on your answers, it could be fairly easy to resolve this.
By the way, if you have a working spreadsheet, attaching a copy of it to your reply post would be very helpful to any of us here desiring to help. Just make sure no private or confidential information is included.
