# GAH! I want a 7!!!! (Word-bar graph help please) **URL:** \ **Category:** Factual Questions\ **Created:** [February 26, 2011, 1:10am UTC](https://boards.straightdope.com/t/gah-i-want-a-7-word-bar-graph-help-please/572654 "2011-02-26T01:10:07Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![congodwarf](https://avatars.discourse-cdn.com/v4/letter/c/e36b37/32.png) [@congodwarf](https://boards.straightdope.com/u/congodwarf)\ **Post date:** [February 26, 2011, 1:10am UTC](https://boards.straightdope.com/t/gah-i-want-a-7-word-bar-graph-help-please/572654/1 "2011-02-26T01:10:07Z")
I am trying to make a bar graph for a lab report. I need the Y-axis to have the numbers 2,4,6,7,8,10,12. I can figure out how to set the minimum and the maximum but I can’t figure out how to get those specific numbers. I can set it for just the even numbers but that doesn’t help with the stupid 7. So, how can I get a 7 in there? ---
**Author:** ![Hunter\_Hawk](https://avatars.discourse-cdn.com/v4/letter/h/50afbb/32.png) [@Hunter\_Hawk](https://boards.straightdope.com/u/Hunter_Hawk)\ **Post date:** [February 26, 2011, 3:30am UTC](https://boards.straightdope.com/t/gah-i-want-a-7-word-bar-graph-help-please/572654/2 "2011-02-26T03:30:40Z")
Why do you specifically need a 7 there? It seems like an odd approach to graph design. Anyhoo, if you really want it, I’d do it the lazy way–take a screenshot of the graph and add the “7” using MSPaint or the equivalent. ---
**Author:** ![congodwarf](https://avatars.discourse-cdn.com/v4/letter/c/e36b37/32.png) [@congodwarf](https://boards.straightdope.com/u/congodwarf)\ **Post date:** [February 26, 2011, 3:54am UTC](https://boards.straightdope.com/t/gah-i-want-a-7-word-bar-graph-help-please/572654/3 "2011-02-26T03:54:18Z")
I need the 7 because it was a pH experiment. Anyway, 7 was one of the standards we used. I _could_ do it without the 7 because all our stuff came in at 6 but I’m a bit anal retentive and I want my graph to reflect each of the standards we used, even though none of our stuff was neutral. Thanks for the suggestion. I’ll give it a try. ---
**Author:** ![johnpost](https://avatars.discourse-cdn.com/v4/letter/j/f17d59/32.png) [@johnpost](https://boards.straightdope.com/u/johnpost)\ **Post date:** [February 26, 2011, 3:56am UTC](https://boards.straightdope.com/t/gah-i-want-a-7-word-bar-graph-help-please/572654/4 "2011-02-26T03:56:21Z")
can you put a tick mark for each number and only label the even numbers? each number value is there just not labeled. ---
**Author:** ![congodwarf](https://avatars.discourse-cdn.com/v4/letter/c/e36b37/32.png) [@congodwarf](https://boards.straightdope.com/u/congodwarf)\ **Post date:** [February 26, 2011, 4:08am UTC](https://boards.straightdope.com/t/gah-i-want-a-7-word-bar-graph-help-please/572654/5 "2011-02-26T04:08:47Z")
AHA!! THAT WORKS! Thank you **johnpost** , I can accept a tick mark instead of a number. I put the major tick marks at the even numbers and the minor tick mark at each number but putting it inside the chart hid the even number marks on the chart lines. So, it looks like I only have odd number marks. ---
**Author:** ![CookingWithGas](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/cookingwithgas/32/485_2.png) [@CookingWithGas](https://boards.straightdope.com/u/CookingWithGas)\ **Post date:** [February 26, 2011, 4:39am UTC](https://boards.straightdope.com/t/gah-i-want-a-7-word-bar-graph-help-please/572654/6 "2011-02-26T04:39:49Z")
Maybe your problem is solved; here is another very clever solution to that sort of thing: > **[Forcing a chart to use the numbers I want](http://www.excelforum.com/excel-general/751904-forcing-a-chart-to-use-the-numbers-i-want.html)** > > Hi, > > So basically what I have is a chart like the one you can see in the attached image. > Now I don't want the chart to show all these numbers (10, 15, 20 etc.), but only show the numbers I wrote down (to the left): 1, 5, 12, 24, 35 and 40. > > How...