Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to create a scatters chart
How to create a scatters chart? It is simple with 2 coluums as below. I tried the wizard but I don't have the x axis with name such as ew, re ytr....Need your help. Daniel name value ew 32 re 43 ytr 23 tre 25 hf 54 gd 52 ht 43 gfd 12 jk 43 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to create a scatters chart
Daniel wrote on Thu, 28 Jun 2007 14:32:03 -0700:
D How to create a scatters chart? It is simple with 2 coluums D as below. I tried the wizard but I don't have the x axis D with name such as ew, re ytr....Need your help. Daniel D name value D ew 32 D re 43 D ytr 23 D tre 25 D hf 54 D gd 52 D ht 43 D gfd 12 D jk 43 Unless you have numerical values in both columns you can't create a real graph (scatter chart). Presumably a line graph would work. James Silverton Potomac, Maryland E-mail, with obvious alterations: not.jim.silverton.at.verizon.not |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to create a scatters chart
An XY (scatter) chart required numerical data for both X and Y. Absent this,
Excel uses the counting numbers 1, 2, 3, etc. as the X values. If the text labels are to be treated as non-numeric labels, create a Line chart, then format the series to remove the lines between the markers. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Daniel" wrote in message ... How to create a scatters chart? It is simple with 2 coluums as below. I tried the wizard but I don't have the x axis with name such as ew, re ytr....Need your help. Daniel name value ew 32 re 43 ytr 23 tre 25 hf 54 gd 52 ht 43 gfd 12 jk 43 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create line chart with two axises in Pivot Chart | Charts and Charting in Excel | |||
How do I create this chart? | Charts and Charting in Excel | |||
How do I create a 4-d chart? | Charts and Charting in Excel | |||
Chart data file lost - need to re-create from chart? | Charts and Charting in Excel | |||
Create a combo chart with two of the same chart types | Charts and Charting in Excel |