Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6
Default Can I select Multiple Items in a Chart

I have a simple Bar Chart, and can't seem to figure out if there is a
way to select, say 5 of the bars and apply color formatting to those 5
all at once. I can select all, and then on the next mouse click, I
can select an individual bar, but in holding down the CTRL, SHIFT, and
ALT keys, I cannot seem to select mutiple items. Is this possible?
Maybe I am trying to group them for formatting purposes.

Thanks,
Brooks

  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: Can I select Multiple Items in a Chart

Hi Brooks,

Yes, it is possible to select multiple items in a chart in Excel. Here's how you can do it:
  1. Click on one of the bars in the chart to select it.
  2. Hold down the CTRL key on your keyboard and click on the other bars you want to select. You should see all the selected bars highlighted.
  3. Once you have selected all the bars you want to format, you can right-click on one of the selected bars and choose "Format Data Series" from the context menu.
  4. In the Format Data Series pane that appears on the right side of the screen, you can choose the "Fill & Line" tab to change the color of the bars.
  5. Make your desired formatting changes and click "Close" when you're done.

That's it! You should now have multiple bars selected and formatted with your desired color.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,489
Default Can I select Multiple Items in a Chart

Hi,

You can select All or 1.
In non 2007 you can make use of the F4 button.
Select the first individual bar and format it. Move to the next bar and
press F4 to apply same formatting.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Brooks" wrote in message
oups.com...
I have a simple Bar Chart, and can't seem to figure out if there is a
way to select, say 5 of the bars and apply color formatting to those 5
all at once. I can select all, and then on the next mouse click, I
can select an individual bar, but in holding down the CTRL, SHIFT, and
ALT keys, I cannot seem to select mutiple items. Is this possible?
Maybe I am trying to group them for formatting purposes.

Thanks,
Brooks


  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6
Default Can I select Multiple Items in a Chart

On May 31, 10:12 am, "Andy Pope" wrote:
Hi,

You can select All or 1.
In non 2007 you can make use of the F4 button.
Select the first individual bar and format it. Move to the next bar and
press F4 to apply same formatting.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excelhttp://www.andypope.info"Brooks" wrote in message

oups.com...

I have a simple Bar Chart, and can't seem to figure out if there is a
way to select, say 5 of the bars and apply color formatting to those 5
all at once. I can select all, and then on the next mouse click, I
can select an individual bar, but in holding down the CTRL, SHIFT, and
ALT keys, I cannot seem to select mutiple items. Is this possible?
Maybe I am trying to group them for formatting purposes.


Thanks,
Brooks



Thanks Andy!

Brooks

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
select multiple items from a dropdown list Rebecca1 Excel Worksheet Functions 0 July 17th 06 08:47 PM
Problem using INDEX to select items in listbox Shazbot Excel Discussion (Misc queries) 3 April 28th 06 09:06 AM
how do I select one from multiple items Jono Excel Discussion (Misc queries) 0 March 15th 06 03:08 PM
order form with multiple items and sizes for items Bernard56 Excel Discussion (Misc queries) 1 January 18th 06 12:43 AM
How do I select multiple data points on my chart? Matthew S Charts and Charting in Excel 1 September 13th 05 06:38 PM


All times are GMT +1. The time now is 07:37 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"