Horizontal Axis

**Wskip49** · 04-07-2011, 03:05 PM

I am having trouble with dates in the horizontal axis. The dates are set in patterns of 3 consecutive, 10/5 10/6 10/7 10/8 10/11 10/12 10/13 10/14 10/18 10/19 10/20 10/21 11/2 11/3 11/4 11/8 11/15 11/16 11/17, however, when I make my graph to chart progress. It give the all the dates between 10/5 and 11/17. My data ranges from 10/5/2010 to 1/26/2011.

**NickyC** · 04-08-2011, 03:08 AM

Hi
Have you tried changing the axis type to "text axis"?

**Wskip49** · 04-08-2011, 08:22 AM

Yes, It will show all the numbers that way. However, the information is not showing correctly. None of the information is correct on the chart. The average is 100 but the line jumps all over the place. I will attach the file again.

**Andy Pope** · 04-08-2011, 08:53 AM

Did you mean to use a stacked line chart?

If you want to display percentages divide you existing data by 100 and plot as percentages.

**Wskip49** · 04-08-2011, 10:44 AM

Yes, I need to show how the student is doing on both interventions. I changed them to percentages and still get incorrect information. I am retiring on Monday afternoon and need to get this to work before then.