Prev: Chart data scrunches to left when adding X axis date series
Next: Display Info in Data Table That is Not Charted?
From: gvm on 9 Feb 2010 23:54
thank you ... Greg

"trip_to_tokyo" wrote:

> Just thinking about what you have said further.
>
> Are you sure you want a line graph?
>
> I think you want a column chart.
>
> This would give you:-
>
> 1. The letter A appearing on the X axis and above that it would show blocks
> (filled columns) representing 23 and 87.
>
> 2. The letter B on the X axis and above that it would show blocks (filled
> columns) representing 200 and 500.
>
> Try a column chart (Clustered Column) and I think that you will arrive at
> the solution you seek.
>
> Please hit Yes if my comments have helped.
>
> Thanks.
>
>
>
> "gvm" wrote:
>
> > I have data that I want to put in a simple line graph: The data is
> > A B
> > 23 200
> > 87 500
> >
> > I mark the 6 cells, select insert chart / line and get a chart with both A
> > and B labels on the x axis. I go to "select data source" and try "switch
> > row/column" and get A and B as series names in the legend. How do I get the
> > label A and the values 23 and 87 on the x axis, and label B and values 200
> > and 500 on the y axis please?
> > (Congratulations Microsoft for making something that was so easy and
> > powerful in Excel 2003 an absolutely primitive disgrace in Excel 2007!) TIA
> > ... Greg
From: Ed Ferrero on 10 Feb 2010 01:09
Hi Greg,

Let's try the failsafe way. This should help in understanding what is going
on behind the scenes.

Select an empty cell in your sheet.
Insert - Line Chart you should see an empty chart
Click the 'Select Data' button on the Chart Tools - Design ribbon
In the Chart data range box, select the cells containing 200 and 500 (i.e.
just the y values)
The 'Legend Entries (Series)' box shows 'Series1' and
the 'Horizontal (Category) Axis Labels' box shows 1, 2
Now click the Edit button under the 'Horizontal (Category) Axis Labels' box
In the selection box for 'Axis Label Range' select the cells that contain
the x values (23 and 87)
Click OK
Click OK

Now add axis titles.

Ed Ferrero
www.edferrero.com

First  |  Prev  | 
Pages: 1 2
Prev: Chart data scrunches to left when adding X axis date series
Next: Display Info in Data Table That is Not Charted?