Highlight all colums in Bar Graph

Parveen · #1 10-25-2005, 11:03 AM

Hi,

I am trying to do a trend line, and inorder to do this, i need to be able to highlight all the columns in my chart. But every time, it won't let me highlight Mar and Aug, but it does hightlight all the others. I have tried doing this both from excel and powerpoint but get the same problem each time. I have also re-entered the data and have changed the figures, but it still won't let me highlight all the colums in the bar graph.

Here is my data

Oct Nov Dec Jan Feb Mar
Early OT 74 60.6 49.7 21.6 28 50.1
Late 26 39.4 50.3 78.4 72 49.9

Apr May Jun Jul Aug Sep
58.7 45.8 64.9 48 64.8 73.2
41.3 52.2 35.1 52 35.2 26.8

Any help much appreciated and if it helps, I can send you the file.

many thanks,

Parveen

#2 10-29-2005, 11:05 AM

Are March and August in one series and the rest of the data is in another?

"Parveen" <Parveen.1xgo6f_1130249123.1649@excelforum-nospam.com> wrote in
message news:Parveen.1xgo6f_1130249123.1649@excelforum-nospam.com...
>
> Hi,
>
> I am trying to do a trend line, and inorder to do this, i need to be
> able to highlight all the columns in my chart. But every time, it won't
> let me highlight Mar and Aug, but it does hightlight all the others. I
> have tried doing this both from excel and powerpoint but get the same
> problem each time. I have also re-entered the data and have changed the
> figures, but it still won't let me highlight all the colums in the bar
> graph.
>
> Here is my data
>
> Oct Nov Dec Jan Feb Mar
> Early OT 74 60.6 49.7 21.6 28 50.1
> Late 26 39.4 50.3 78.4 72 49.9
>
> Apr May Jun Jul Aug Sep
> 58.7 45.8 64.9 48 64.8 73.2
> 41.3 52.2 35.1 52 35.2 26.8
>
> Any help much appreciated and if it helps, I can send you the file.
>
> many thanks,
>
> Parveen
>
>
> --
> Parveen
> ------------------------------------------------------------------------
> Parveen's Profile:
> http://www.excelforum.com/member.php...o&userid=28328
> View this thread: http://www.excelforum.com/showthread...hreadid=479101
>

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)