Formatting a single horizontal gridline on a graph

**brdmartin** · 07-13-2015, 11:37 PM

Hi,
I'm working on an excel document that will graph test scores, so that I can paste them into my psychological reports. I am trying to format a single gridline to be darker, indicating the average standard score for the test. I know it is possible, because I somehow already did it to two of the graphs, but I can't figure out how I did it now, after spending more than an hour trying everything I can think of. On the two graphs where I was already successful on the WISC tab, the one gridline that I've changed can be selected separately from all the others, while all the other gridlines continue to function all together, as a single entity. So basically, my question is how can I make a single gridline on a graph function independently from all the others, so that I can then format it differently?

On a somewhat related question, is there a way to put a borderline on the right and top of the plot field, so the plot field is within a defined square/rectangle? The top borderline is needed because the scores range from 30 to 85, the major unit needs to be 10, and I really really don't want to use minor gridlines.

Thanks,
Brian

**JeteMc** · 07-17-2015, 02:48 PM

If you are talking about a line like the one that I added to the chart on the "Conners" page, follow the directions in this article: http://peltiertech.com/Excel/Charts/...orzSeries.html. The one difference I noticed using Excel 2010 is instead of "Select and copy this range, select the chart, and from the Edit menu", I just chose paste special from the home tab.
It is also possible, and perhaps easier, to just select the chart and the Insert tab look on the Illustration pane and select Shapes and then select the line as I did on the chart on the "ASRS" tab.

Copy of (Assessment Grapher).xlsx

Hope this helps.

**brdmartin** · 07-17-2015, 09:19 PM

That might work, I'll have to play with it. The example I was successful was actually on the WISC page. I didn't draw any kind of extra line on that one, I was just able to format one of the lines on the graph darker than the others. Thanks for the help.

**brdmartin** · 07-26-2015, 05:37 PM

It works within excel, but when I paste a graph into a word document, the inserted line moves, and is no longer on the average score [which is 50 for T-scores, 100 for standard scores, 10 for scaled scores]. When I try to move the line back to where it is supposed to be, it moves in much larger segments within word than it does in excel, and I cannot line it up on the 50 mark.

**JeteMc** · 07-27-2015, 03:42 PM

You may have already looked at articles like Convert-Excel-to-Word, however I used the second part, "Method 2 of 2: Inserting an Excel Chart into Word" and pasted the "Conners" chart and average score line into MS Word.

**brdmartin** · 07-27-2015, 04:11 PM

Just tried it again, and selected to keep source formatting, but the same issue apples- everything carries over just fine, except the inserted line is moved so that it no longer is aligned with the average score. When I try to move the line back to where is is supposed to be, it cannot be done because it can only be moved in large segments, and can only be placed either above or below the average score.

**JeteMc** · 07-27-2015, 05:19 PM

Sorry that you are not able to get the chart, especially the inserted line, to copy correctly. Only advice that I can think of would be to contact Microsoft directly.

**brdmartin** · 07-27-2015, 05:52 PM

Thanks very much for your help with this. Anyone else have any ideas?

**JeteMc** · 07-27-2015, 06:33 PM

This would be where I would start.

**brdmartin** · 08-07-2015, 05:55 PM

I figured out how I did it. I did a right click, and selected format axis. In the box that says "horizontal axis crosses at" box, I put in the value of the gridline I want to format differently. The gridline can then be selected separately from the others, using the format axis menu item.

Formatting a single horizontal gridline on a graph

LinkBack

Thread Tools

Rate This Thread

Display

Formatting a single horizontal gridline on a graph

Re: Formatting a single horizontal gridline on a graph

Re: Formatting a single horizontal gridline on a graph

Re: Formatting a single horizontal gridline on a graph

Re: Formatting a single horizontal gridline on a graph

Re: Formatting a single horizontal gridline on a graph

Re: Formatting a single horizontal gridline on a graph

Re: Formatting a single horizontal gridline on a graph

Re: Formatting a single horizontal gridline on a graph

Re: Formatting a single horizontal gridline on a graph

Thread Information

Users Browsing this Thread

Similar Threads

How do you shade below a specific gridline of a line graph?

Graph problem, single value spread equally over a timescale on a graph

Horizontal High low Graph

Remove gridline from single worksheet

To-do List Horizontal Bar Graph

Excel 2007 : mutiple horizontal axises with a single vertical axis in a graph

Horizontal Bar Graph

[SOLVED] How to format an isolated value and gridline on my graph?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions