Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Overlap 1 "sum bar" to others
Hi all.
Title may sound strange but it exactly explain the situation: I have a table like this: M F TOT ------------------- 1990 5 10 15 1993 8 2 10 1996 9 9 18 1999 1 5 6 I NEED an histogram with 3 colums (male, female, total), where the "TOTAL" bar is OVERLAPPED UNDER the 2 "M" and "F" bars. Is there a way? Excel? Addins? Plug-ins? External software? Thanks!! P.S. I REALLY need help (as soon as possible) |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Overlap 1 "sum bar" to others
I don't know what you mean by overlapped. The only thing I can think of is
perhaps you want M and F side by side, in a clustered column chart, and the total charted but under both and not beside them. Make a clustered column chart with all of the three data series. Double click the M series, and on the Axis tab, select Secondary. Select the F series and press the F4 key to repeat. Go to Chart Options on the Chart menu, click on the Axes tab, and uncheck any secondary axis box which is checked. Now you can adjust the relative gap width of the column series to make the totals columns wider (if you want). - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Terno" wrote in message oups.com... Hi all. Title may sound strange but it exactly explain the situation: I have a table like this: M F TOT ------------------- 1990 5 10 15 1993 8 2 10 1996 9 9 18 1999 1 5 6 I NEED an histogram with 3 colums (male, female, total), where the "TOTAL" bar is OVERLAPPED UNDER the 2 "M" and "F" bars. Is there a way? Excel? Addins? Plug-ins? External software? Thanks!! P.S. I REALLY need help (as soon as possible) |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Overlap 1 "sum bar" to others
Jon Peltier ha scritto: I don't know what you mean by overlapped. The only thing I can think of is perhaps you want M and F side by side, in a clustered column chart, and the total charted but under both and not beside them. Make a clustered column chart with all of the three data series. Double click the M series, and on the Axis tab, select Secondary. Select the F series and press the F4 key to repeat. Go to Chart Options on the Chart menu, click on the Axes tab, and uncheck any secondary axis box which is checked. YES!! YES!!! That's the way!! You understood perfectly!! Thanks for GREAT help!! Bye |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I overlap only two of four data series in Excel Column Chart? | Charts and Charting in Excel | |||
bars overlap, how do I stop this? | Charts and Charting in Excel | |||
off-setting points of different series b/c error bars overlap | Charts and Charting in Excel | |||
Removing overlap of bars when 2 Y axes are used | Charts and Charting in Excel | |||
how can I have no overlap bars when using axis2? | Charts and Charting in Excel |