Re: Bar Chart template

From: Andy Pope (andy_at_andypope.info)
Date: 03/01/04 

Date: Mon, 01 Mar 2004 10:13:40 +0000

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

Wuxx0153 wrote:

> 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 

-- 
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Relevant Pages

  • Re: Split Values with JFreeChart ?
    ... >> I'm in charge of writing an application that can display a chart, ... > And you want to display it using a stacked bar chart? ... How do I make each of the bar split into sub-values? ...
    (comp.lang.java.gui)
  • Re: urgently:How to use the control MSChart?
    ... I'm sorry, no, I don't really know anything about the chart control; ... Plus it's easy to draw horizontal lines. ... Here's some code that can draw a bar. ... When you display a data series in stacked bar format, ...
    (microsoft.public.vc.mfc)
  • Re: Finding the Y-Value of Points
    ... data series that make up each chart have the values of the points ... Due to the complex formatting of the charts, ... display the values using Data Labels, so I display them in Text Boxes. ... I got the value associated with each bar from the actual cells ...
    (microsoft.public.excel.programming)
  • Re: bars overlap, how do I stop this?
    ... On your chart, rightmouse and select Chart Type, then select a chart ... style that does not overlap like the first standard Column or the first ... I want to show the data in bar ... > format, but the bars overlap. ...
    (microsoft.public.excel.charting)
  • Re: Bars for various ranges of workhours
    ... Select the entire range and choose Insert, Bar, Stacked Bar ... With the chart selected choose Chart Tools, Design, Switch Row/Column ... Select the range and click the Charting toolbar button ... so I could see that I have 3 employees that overlap ...
    (microsoft.public.excel.charting)
Quantcast