RE: Chart problem

Hard to know where the issue is from here..

If you have for example.. Dates in column A, value x down column B, and
value Y down column C...

use Clustered column Type, will show two columns per date. When you say one
in front of the other.. do oyu mean on top of, or do you have them going
vertically and to the right of?

Those would be stacked columns or bars. Don't want those...

"Igor" wrote:

Hello,

I have the following problem:

I have 2 series which I need to represent with a column chart, using a
primary and seconday Y-Axis. In each period in the X-Axis I need to have 2
columns, one next to the other. But what I'm getting is 2 columns, one in
front of the other.

I have tried to solve this by formatting the data series, without positive
results.

Can anyone, please, help me?

(I'm using Excel 2003.)


--

igor
.

Relevant Pages

  • RE: Format Data Series in a Pivot Chart
    ... create the graphs as non pivot.That way I will keep the formatting. ... I have 2 pivot charts, which both have the same data series, but depending ... .Weight = xlThin ... .LineStyle = xlContinuous ...
    (microsoft.public.excel.programming)
  • Re: chart dates and times (excel 2007)
    ... too helpful and think that this column is any data series rather than your ... This will be ignored by the chart engine while a blank would be treated as ... event times on y-axis where the y-axis is measured off at 15 minute ... line running along the x-axis and that too starting after the last ...
    (microsoft.public.excel)
  • Re: Excel charts copied to powerpoint
    ... powerpoint. ... There are multiple data series in the chart. ... Right click on the X-axis and choose "Format Axis." ...
    (microsoft.public.excel.charting)
  • Re: Why Color Flled Data Series on Line Chart Slants
    ... Are you using a couple of data series as areas to provide the shading? ... If so you probably have a slanted line at the separation point as one series drops to zero and the other starts from zero. ... the point of a given month on the line is not matching up with that same point/month of the x-axis. ... Jon Peltier, Microsoft Excel MVP ...
    (microsoft.public.excel.charting)
  • RE: Conditional Formatting for #DIV/0!
    ... The formula solutions are considered better solutions than using conditional ... formatting, but if you really wanted to use formatting assume that the top ... Choose Format, Cells, and from the first drop down pick Formula is ...
    (microsoft.public.excel.misc)
Loading