How do I make histogram graphs look the same?

B

Boatman

I have to make a series or group of histogram graphs which I would like to
make look basically the same. I am using the histogram tool from the
analysis toolpack with Excel 97. Each time i use this tool on a set of data,
it produces a rather small graph which I then must customize, and in
particular, make larger. Every graph I make looks a little different. I
tried copying| special| format with little success. I have thought of
recording a macro as I customize one. Are there any other suggestions?

Thanks!

Boatman
 
C

Claus Dietrich

make one histogram as you like it. Then
-chart
-chart type
-Custom Types
-user defined
-set as default

this should be used with same borders and scale and colors and .... as first

--
Gruß / regards
Claus Dietrich :)

IBM Ehningen, AMS Competency Services,
Dept. 4765, Addr. D-71139-03-2102
Fon: +49 (0) 7034 15 2735 (internal *119 - 2735, Fax - 3400)
mailto:[email protected]
 
B

Boatman

Thanks, Claus. You turned me on to a feature of Excel I was not familiar
with.

Hank
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I create a Cumulative Frequency Histogram on Excel? 1
How do I make a circle graph? 1
How do I change the data set on the X axis? (office 2003) 1
How do I make a histogram in MS Excel? 1
How do I keep formatting when creating a chart from a pivot? 2
How do I find the record source of a graph ??? 1
How do you specify bin ranges for the Histogram analysis tool? 1
How to make Primary axis and Secondary X-axis have the same scale 0

Top