Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Parveen
 
Posts: n/a
Default Highlight all colums in Bar Graph


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

  #2   Report Post  
Barb Reinhardt
 
Posts: n/a
Default Highlight all colums in Bar Graph

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

"Parveen" wrote in
message ...

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Graph with pivot table Richard Vajsar Excel Discussion (Misc queries) 1 July 18th 05 11:04 PM
How do I create a combination graph with stackedColumns+lineGraph ChartQuestion Charts and Charting in Excel 1 June 14th 05 12:39 PM
Line Graph Data Recognition Nat Charts and Charting in Excel 2 April 30th 05 02:07 PM
Can I use side by side colums and stacked columns in same graph? Debbie Charts and Charting in Excel 1 December 29th 04 06:01 PM
Graph Axes Robin Excel Discussion (Misc queries) 0 December 8th 04 08:03 PM


All times are GMT +1. The time now is 05:47 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"