Chart Problems

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Dave (anonymous_at_discussions.microsoft.com)
Date: 04/21/04 

Date: Wed, 21 Apr 2004 11:21:23 -0700

I usually plot them on separate axes. In this case I
would set up Population as a bar graph on the primary Y
axis. Then I'd set Gal/Capita as a line series on the
Secondary Y axis. Set them up both as lines first, then
select the Population line, right-click, and change the
graph type to Bar. I think you can then find where to
set the Gal series to the secondary Y axis.

Hope this helps.

>-----Original Message-----
>I am having problems trying to chart information due to
>the large descrepency in numbers. This is the
information
>I am trying to graph:
>
>Year Population Gal/Capita
>92/93 213,516 261
>93/94 214,000 227
>94/95 215,000 218
>95/96 225,000 231
>96/97 230,000 312
>97/98 230,000 286
>98/99 236,298 221
>99/00 249,849 270
>00/01 253,119 267
>01/02 267,000 238
>02/03 271,221 237
>
>I would appreciate any ideas or suggestions...
>
>Thanks!
>
>Stacy
>.
>

Relevant Pages

  • Re: Vertical Lines on the Lines on 2 Axes Chart
    ... I've tried starting with the line graph and adding a bar graph series ... axis' used up. ... Jon Peltier, Microsoft Excel MVP ...
    (microsoft.public.excel.charting)
  • Re: Changing chart types with series
    ... axis. ... You need some dummy column series that are hidden but still take up ... I currently have a graph comprised of 4 different series. ... graphs is overtop of the other bar graph meaning I can't see that series. ...
    (microsoft.public.excel.charting)
  • Charting two axes
    ... Revenue $ on left axis using bar graph ... Two Gross Profit % (GAAP and Proforma) on right axis using ... I can only get one bar and one line graph using the custom ...
    (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: Automatic swap of x - and y - axis
    ... of the chart, and a description of the problem, someone may be able to help. ... Jon Peltier, Microsoft Excel MVP ... by the time the graph is ... Are the values that were plotted on the horizontal axis now ...
    (microsoft.public.excel.charting)