Bar Chart template

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to creat a bar chart with an unequal space timeline, but when I change x-axis to fit the time scale, the bar become very thin
How can I make those bar fatter

I need a template for a different bar chart
I have 2 groups of data in each time point, and each group has 2 data point (measurement and background)
I would like to have is a bar chart has 2 bars in each time point. Within each bar, the y-axis scale is fit to match maesurement, but it also display a different color for background
(for example measurement is 3 and backgroung is 1.2. Then I would like the bar is in the scale of 0 to 3, but in the scale of 0 to 1.2, there is different color. At each time point, there is 2 such bar. Of course it is unequal space timeline

Can anyone tell me how to creat such bar chart in Excel (I am using Office 2000)
If Excel cannot do that (my boss say he cannot make Excel do this), is there any software I can use

Thanks
 
Hi,

Assuming your data is in 3 columns, Date | Measure | Background
Create a clustered column chart.
Double click one of the column series in order to display the format
dialog. On the options tab set the Overlap to 100 and the Gap to 0.
This will give you the widest possible bar, which is dependent on the
size of the plot area and the number of dates on the axis.
By reducing the Overlap it should place the background column in front
of the measurement column.
If the background value can exceed either the 1.2 limit or be larger
than the corresponding Measurement value then you will need to create
two 'helper' columns from which to chart.

Cheers
Andy
 
The limit to the width of the bar is the width of one full day on the
category axis.

- Jon
 
it is 5 column date group 1 measure group 1 background group 2 measure and group 2 background
I can make it work by creating second axis; however in this I might need third axis (the will be a line chart display the ratio of measure and background)

Can Excel do third y-axis?

thanks
 
Back
Top