Results 1 to 2 of 2
Thread: blanks in bar chart (XP)
2005-01-11, 17:53 #1
- Join Date
- Feb 2002
- Taranaki, New Zealand
- Thanked 0 Times in 0 Posts
blanks in bar chart (XP)
Happy new year to all of you
I have been asked to create a rather large bar chart. People will fill the questionnaire out and email me the results. Most have 5 results.. seldom - sometimes etc.
One of the charts only has entries in the first column and the last.
It has very hard to determine where the bars belong. Is there a way I can delete/remove the spaces between the bars, so its obvious where the reuslts belong.
I find this hard to explain so I have attached a simple chart.
2005-01-11, 18:02 #2
- Join Date
- Jul 2002
- Pittsburgh, Pennsylvania, USA
- Thanked 342 Times in 335 Posts
Re: blanks in bar chart (XP)
You can remove them:
1)get rid of the other entries which have not data
2)Reorder the series:
Dbl-click one of the series
click on series order (tab)
Select the Often and <moveUp>
select the N/A and <move down>
3) add horiz gridlines to mark the Questions better
Right click on chart
Choose chart options
Choose "major axis" for category(x)