Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Help with X- Axis!!!
Hi. I am trying to graph data in Excel. My x-axis is days. I have data
points for Day 1, Day 4 and Day 10. When I graph, it doesn't space the data points proportionally. There is the same distantance between 1 & 4 as there is between 4 & 10. Its like it gets treated as categorical versus numerical. Any guidance would be greatly appreciated. Also, is there a way that I can insert tick marks on the x-axis only where I have data points (only on days 1, 4 and 10 on the example above)? Thank you. Chris |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Help with X- Axis!!!
Are you using a line chart? It sounds like you need an XY chart instead.
[XY can include lines, with or without data point symbols.] -- David Biddulph "CMD" wrote in message ... Hi. I am trying to graph data in Excel. My x-axis is days. I have data points for Day 1, Day 4 and Day 10. When I graph, it doesn't space the data points proportionally. There is the same distantance between 1 & 4 as there is between 4 & 10. Its like it gets treated as categorical versus numerical. Any guidance would be greatly appreciated. Also, is there a way that I can insert tick marks on the x-axis only where I have data points (only on days 1, 4 and 10 on the example above)? Thank you. Chris |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Help with X- Axis!!!
Thank you David. Yes, that works however, I am going to make it more
complicated..... I am trying to use the graph option that allows me to plot 2 graphs with a y-axis on the right and 1 on the left. I have inserted blank rows between my data points. I then went to tools-- options-- chart and said to interpolate between the blank cells. My last challenge is this: If I have 3 points that are plotted (Day 1, Day 4 and Day 10), can I customize my axis axis so that I only see tick marks/labels for those 3 points where I have data.....rather than seeing 2,4,6,8,10? Thanks. "David Biddulph" wrote: Are you using a line chart? It sounds like you need an XY chart instead. [XY can include lines, with or without data point symbols.] -- David Biddulph "CMD" wrote in message ... Hi. I am trying to graph data in Excel. My x-axis is days. I have data points for Day 1, Day 4 and Day 10. When I graph, it doesn't space the data points proportionally. There is the same distantance between 1 & 4 as there is between 4 & 10. Its like it gets treated as categorical versus numerical. Any guidance would be greatly appreciated. Also, is there a way that I can insert tick marks on the x-axis only where I have data points (only on days 1, 4 and 10 on the example above)? Thank you. Chris |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Help with X- Axis!!!
To get 'correct' spacing you need an XY chart with 1, 4, 10
If you have Day 1, Day 4 , etc you have categorical data and can make a line or column chart. If you want a line/column chart with 'correct' spacing use Day 1, Day 2, Day 3.... and for the x-values use =NA() best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "CMD" wrote in message ... Hi. I am trying to graph data in Excel. My x-axis is days. I have data points for Day 1, Day 4 and Day 10. When I graph, it doesn't space the data points proportionally. There is the same distantance between 1 & 4 as there is between 4 & 10. Its like it gets treated as categorical versus numerical. Any guidance would be greatly appreciated. Also, is there a way that I can insert tick marks on the x-axis only where I have data points (only on days 1, 4 and 10 on the example above)? Thank you. Chris |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Help with X- Axis!!!
Thank you Bernanrd....can you please explain what you mean by set x values =
to NA()? Thanks again in advance. Chris "Bernard Liengme" wrote: To get 'correct' spacing you need an XY chart with 1, 4, 10 If you have Day 1, Day 4 , etc you have categorical data and can make a line or column chart. If you want a line/column chart with 'correct' spacing use Day 1, Day 2, Day 3.... and for the x-values use =NA() best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "CMD" wrote in message ... Hi. I am trying to graph data in Excel. My x-axis is days. I have data points for Day 1, Day 4 and Day 10. When I graph, it doesn't space the data points proportionally. There is the same distantance between 1 & 4 as there is between 4 & 10. Its like it gets treated as categorical versus numerical. Any guidance would be greatly appreciated. Also, is there a way that I can insert tick marks on the x-axis only where I have data points (only on days 1, 4 and 10 on the example above)? Thank you. Chris |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
Help with X- Axis!!!
When you have missing data in the range of holding the x-values, it is best
to fill the blanks with =NA(). This displays as #N/A and is ignore by the chart engine. best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "CMD" wrote in message ... Thank you Bernanrd....can you please explain what you mean by set x values = to NA()? Thanks again in advance. Chris "Bernard Liengme" wrote: To get 'correct' spacing you need an XY chart with 1, 4, 10 If you have Day 1, Day 4 , etc you have categorical data and can make a line or column chart. If you want a line/column chart with 'correct' spacing use Day 1, Day 2, Day 3.... and for the x-values use =NA() best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "CMD" wrote in message ... Hi. I am trying to graph data in Excel. My x-axis is days. I have data points for Day 1, Day 4 and Day 10. When I graph, it doesn't space the data points proportionally. There is the same distantance between 1 & 4 as there is between 4 & 10. Its like it gets treated as categorical versus numerical. Any guidance would be greatly appreciated. Also, is there a way that I can insert tick marks on the x-axis only where I have data points (only on days 1, 4 and 10 on the example above)? Thank you. Chris |
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
Help with X- Axis!!!
Great. Thanks very much.
"Bernard Liengme" wrote: When you have missing data in the range of holding the x-values, it is best to fill the blanks with =NA(). This displays as #N/A and is ignore by the chart engine. best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "CMD" wrote in message ... Thank you Bernanrd....can you please explain what you mean by set x values = to NA()? Thanks again in advance. Chris "Bernard Liengme" wrote: To get 'correct' spacing you need an XY chart with 1, 4, 10 If you have Day 1, Day 4 , etc you have categorical data and can make a line or column chart. If you want a line/column chart with 'correct' spacing use Day 1, Day 2, Day 3.... and for the x-values use =NA() best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "CMD" wrote in message ... Hi. I am trying to graph data in Excel. My x-axis is days. I have data points for Day 1, Day 4 and Day 10. When I graph, it doesn't space the data points proportionally. There is the same distantance between 1 & 4 as there is between 4 & 10. Its like it gets treated as categorical versus numerical. Any guidance would be greatly appreciated. Also, is there a way that I can insert tick marks on the x-axis only where I have data points (only on days 1, 4 and 10 on the example above)? Thank you. Chris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need PivotChart x axis to cross Y axis at minimum Y axis value | Charts and Charting in Excel | |||
can I make the vertical axis the category axis in Excel line graph | Charts and Charting in Excel | |||
Adding data on Axis Major Gridlines next to Category Axis Collums | New Users to Excel | |||
How to insert X axis scale values next to axis and X axis grid lin | Charts and Charting in Excel | |||
Secondary Axis Annual Units sold on 1 Y Axis - Dollar Volume on another | Charts and Charting in Excel |