Re: P & V chart: Secondary X axis gradient (again)

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: wlotto (anonymous_at_discussions.microsoft.com)
Date: 03/11/04 

Date: Thu, 11 Mar 2004 07:01:50 -0800

Data is like this. Some dates are skipped. One day or
sometimes one week (Real data covers for a couple of
years.) What I have to do is:

1. Close - left Y. Volume - right Y.
2. Beginning date and ending date have to be shown
exactly at the ends of X axis.
3. Skipped dates cannot have spaced. Has to be shown
continuously.
4. Change the background (only plot area) to two color
gradient.

*BTW, why stacked column? Not a clustered column?

Date Volume Close
3/2/04 14044549 98.24
3/3/04 13637071 107.55
3/5/04 10899971 98.30
3/6/04 9771689 97.16
3/7/04 11143407 96.02
3/9/04 9886843 93.74
3/10/04 8758561 117.6033333
3/11/04 10130279 116.4633333
3/12/04 9001997 115.3233333
3/14/04 6745433 113.0433333

>-----Original Message-----
>I'm going to start over.
>
>In your first post, you said you want a chart with
volume as columns and
>price as XY. This will also work with the price on a
Line chart.
>
>If the data is arranged like this, it will be easy to
make the chart:
>
>Date Volume Close
>3/2/2004 14044549 98.24
>3/3/2004 13637071 107.55
>3/4/2004 11787985 95.96
>
>1. Select the data and make either a Line or a Scatter
chart.
>2. Right click on the Volume series, select Chart Type
from the pop up
>menu, and choose the Stacked Column option.
>3. (see NOTE below) Double click on the X axis, Scale
tab, check Value
>Axis Crosses at Maximum Category.
>4. Double click on the Price series, click on the Axis
tab, and choose
>Secondary.
>
>NOTE: If you make the Volume series the secondary
series, it will make
>formatting the X axis more difficult. If you want volume
on the right
>axis, and price on the left, follow all steps. If you
want volume on the
>left and price on the right, skip step 3.
>
>If you follow these steps, whether you choose Line or
Scatter for your
>Price chart type, the chart will be substantially the
same. Don't let
>the name of the chart type fool you. Either type series
can be formatted
>to look the same: with or without markers, with or
without connecting
>lines.
>
>- Jon
>-------
>Jon Peltier, Microsoft Excel MVP
>Peltier Technical Services
>http://PeltierTech.com/Excel/Charts/
>_______
>
>wlotto wrote:
>
>> 'Category' of Value(X)Axis (Primary axis) is dimmed
(both
>> Automatic and Timescale are also dimmed).
>>
>> I can select Category for Secondary Axis (Category(X)
>> axis). When I select this, every problem happens.
>>
>> Why selections for Value(X) axis are dimmed?
>>
>> thanks.
>>
>>>-----Original Message-----
>>>I'm not really sure I understand what you're doing. If
>>
>> you have time
>>
>>>based data with gaps, and you don't want the gaps to
>>
>> show, you can
>>
>>>change to a category axis. Right click on the chart,
>>
>> choose Chart
>>
>>>Options from the pop up menu, and on the Axes tab,
>>
>> change the X Axis
>>>from Automatic or Time Scale to Category.
>>
>>>- Jon
>>>-------
>>>Jon Peltier, Microsoft Excel MVP
>>>Peltier Technical Services
>>>http://PeltierTech.com/Excel/Charts/
>>>_______
>>>
>>>wlotto wrote:
>>>
>>>
>>>>It did not work. There may be some trick with it but
I
>>>>couldn't find it either.
>>>>
>>>>OK let me explain a bit more.
>>>>Category data is one year date, yet, it is not 365
>>
>> days.
>>
>>>>Some skipps here and there throughout, therefore,
>>
>> there
>>
>>>>is a space among columns accordingly. I am trying to
>>
>> fill
>>
>>>>the space out by creating secondary X axis. (I hope I
>>
>> am
>>
>>>>doing right.)
>>>>
>>>>By doing so, I can successfully fill the space by
>>
>> making
>>
>>>>a bit of change (making weight thiker, etc.) But I
>>
>> don't
>>
>>>>know how to make the area (that is a plot area
without
>>>>secondary X axis) gradient.
>>>>
>>>>Thanks.
>>>>
>>>>
>>>>>-----Original Message-----
>>>>>Richard -
>>>>>
>>>>>An off-topic word to the wise. I know it's only a
>>>>
>>>>hotmail account, but
>>>>
>>>>
>>>>>if you don't do something to disguise it, you'll be
>>>>
>>>>fighting off
>>>>
>>>>
>>>>>mountains of spam in your inbox.
>>>>>
>>>>>- Jon
>>>>>-------
>>>>>Jon Peltier, Microsoft Excel MVP
>>>>>Peltier Technical Services
>>>>>http://PeltierTech.com/Excel/Charts/
>>>>>_______
>>>>>
>>>>>richard_b_schramm@hotmail.com wrote:
>>>>>
>>>>>
>>>>>
>>>>>>right click on the 'volume' data series and
>>>>>>select 'format data series'. On the 'Patterns' tab,
>>>>>>click 'fill effects'. from there you can pick your
>>>>>>gradient colours.
>>>>>>
>>>>>>Richard
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>>-----Original Message-----
>>>>>>>I created a typical price&volume graph. Price/XY,
>>>>>>>Volume/Column. I put Secondary Category (X),
>>
>> Category
>>
>>>>in
>>>>
>>>>
>>>>>>>order not to break columns.
>>>>>>>
>>>>>>>Q. How could I change Volume's color (on Secondary
X
>>>>>>>axis) to gradient (two colors)?
>>>>>>>.
>>>>>>>
>>>>>
>>>>>.
>>>
>>>.
>>>
>
>.
>

Relevant Pages

  • Re: Consolidate my data and plot on a dual axis chart
    ... Make an XY chart with one set of data, ... My price data is in 2 columns but somehow I need to combine to make 1 ... if the dates/times for bid ... If you need a line chart (the only reason is the nice X axis date ...
    (microsoft.public.excel.charting)
  • Re: Automatic swap of x - and y - axis
    ... Dim cht As Chart ... have checked last years databases and graphs appear to be o.k. ... They upgraded to Excel 2007 in June/July. ... Are the values that were plotted on the horizontal axis now plotted on ...
    (microsoft.public.excel.charting)
  • Re: Timeline chart from text containing cells
    ... So it's like a Gantt chart with products on the vertical axis, ... Under Category Axis, ... or you can add the label to the points. ...
    (microsoft.public.excel.charting)
  • Re: Automatic swap of x - and y - axis
    ... that would keep the chart in its intended configuration. ... Jon Peltier, Microsoft Excel MVP ... The graph changes not when data are entered, ... Are the values that were plotted on the horizontal axis now plotted ...
    (microsoft.public.excel.charting)
  • Re: multiple colors on area chart
    ... The recession data is on the secondary axis with a chart type "columns." ...
    (microsoft.public.excel.charting)