hey!
I am using Excel 2003. I have large amounts of data stored in multiple sheets in one workbook. I need to draw a single histogram for the data present in these sheets. How can I do that? The data Analysis tool is not helping as it draws the bin-frequency histogram, considering data from one sheet only. Does somebody know the answer?
Hello,
create a chart with the data from the first sheet.
Select the data on the next sheet and copy the range.
Select the chart and use Paste Special. Accept the defaults. The data from the second sheet will now be plotted in the chart.
It is more advisable, though, to create a data table in one sheet and build your chart on that. If you use the Analysis ToolPak histogram, your data needs to be on one sheet only.
If you need help arranging that, please pipe up.
cheers,
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks