Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart Won't Display Properly
Would really appreciate some help with this ...
Trying to put the following data into a chart, which shows the the spread of employees over certain ages: Age Number 22 3 25 2 26 3 27 11 28 17 29 18 30 15 31 22 32 16 33 21 34 32 - The way I want this to work is to have the ages ascending on the x axis and the number shown in columns for the y axis. *But* when I use the auto-chart feature, it puts this into two data series, one for Age & one for Number, with a load on nonsense on the x & y axes.. Please help!! Many thanks, Kelvin |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart Won't Display Properly
On Mon, 22 Oct 2007, in microsoft.public.excel.charting,
Kelvin said: The way I want this to work is to have the ages ascending on the x axis and the number shown in columns for the y axis. *But* when I use the auto-chart feature, it puts this into two data series, one for Age & one for Number, with a load on nonsense on the x & y axes.. There's two things you need to do that Excel isn't good at prompting you to do. One is to choose as a chart type, not Line Chart, but XY (Scatter) Chart. The other is to (for now) leave the cell where you currently have "Age" blank. The blank cell is to cue the Excel Chart Wizard which rows are the labels, and which columns are the X-axis. Try that and see if it helps. After you've made the chart, it's okay to put the word "Age" back in. -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart Won't Display Properly
EXCELLENT!!
That works fine and you have certainly saved me from ending up in poo creek at work - they might even let me come back next week!! All the best "Del Cotter" wrote: On Mon, 22 Oct 2007, in microsoft.public.excel.charting, Kelvin said: The way I want this to work is to have the ages ascending on the x axis and the number shown in columns for the y axis. *But* when I use the auto-chart feature, it puts this into two data series, one for Age & one for Number, with a load on nonsense on the x & y axes.. There's two things you need to do that Excel isn't good at prompting you to do. One is to choose as a chart type, not Line Chart, but XY (Scatter) Chart. The other is to (for now) leave the cell where you currently have "Age" blank. The blank cell is to cue the Excel Chart Wizard which rows are the labels, and which columns are the X-axis. Try that and see if it helps. After you've made the chart, it's okay to put the word "Age" back in. -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help - cannot compare values properly even though they display same thing! | Excel Discussion (Misc queries) | |||
PLS HLP Waterfall doesn't display properly | Charts and Charting in Excel | |||
how do I get the axis titles to display properly in ms graph 03? | Charts and Charting in Excel | |||
Heartbroken: custom chart markers don't display properly in PowerPoint | Charts and Charting in Excel | |||
I have a problem to properly display the title of Value (Y) axis i | Charts and Charting in Excel |