Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
XY-charts with non numerical x axis
Hi! I have two data series´, one i column A and one i column B. Column A
consits of non numerical informatioon eg names of cities and column B consits of numerical information. Eg I have A: new York,new york,new york london, tokyo, tokyo and B:5,10,2,7,11,12. I want to create a chart where i have the names on the cities on the x axis and the vaules corresponding to each city on the y-axis. the values must be displayed as dots, not as bars. On the x axis I only want one place where it says New york etc. Is this possible? I have tried but did not manage. I always get three places on the axis where it says new york. appreciate any help! thanks |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
XY-charts with non numerical x axis
Hi,
First plot the chart as lines and then select each series and format it to show None for Line. How do you want to plot the data - 3 data points for a city that appears 3 times? a count of the number of times a city appears, the sum of the values for a given city? Is new York different from new york? -- If this helps, please click the Yes button Cheers, Shane Devenshire "Arne Hegefors" wrote: Hi! I have two data series´, one i column A and one i column B. Column A consits of non numerical informatioon eg names of cities and column B consits of numerical information. Eg I have A: new York,new york,new york london, tokyo, tokyo and B:5,10,2,7,11,12. I want to create a chart where i have the names on the cities on the x axis and the vaules corresponding to each city on the y-axis. the values must be displayed as dots, not as bars. On the x axis I only want one place where it says New york etc. Is this possible? I have tried but did not manage. I always get three places on the axis where it says new york. appreciate any help! thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
graphing numerical values on the x-axis | Charts and Charting in Excel | |||
How change worksheet axis to alpha numerical not both numer | Excel Discussion (Misc queries) | |||
How do I make a graphic with non-numerical data on X axis ? | Charts and Charting in Excel | |||
Bubble Charts with two non-numerical variables | Excel Worksheet Functions | |||
Changing Y-Axis Labels from Numerical to Textual | Charts and Charting in Excel |