Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
Barb Reinhardt
 
Posts: n/a
Default how do you change bars into lines on a chart

Select the series you want to change and right click on it. You should see
an option for Chart Type. Change from Line to Bar or vice versa.

"BJ" wrote in message
...
I am trying to chart multiple years with multiple data
ie 2 yrs each with 2 business units, each having GM & OP

i want all GM to be bars & all OP to be lines. Excell automatically does
this, but not how i would like

Please help



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
Producing line and bar graphs on same axis smurray444 Charts and Charting in Excel 1 November 21st 05 05:20 PM
How can I change a graph with 2 bars,2 lines to 3 bars, 1 line? IOWAJulie Charts and Charting in Excel 3 October 19th 05 11:13 PM
2 Bars and 2 Y Axis Chart DG Charts and Charting in Excel 1 October 4th 05 03:03 AM
Macro to change Chart Range when inserting a column Mark Charts and Charting in Excel 1 September 13th 05 01:12 PM
Urgent Chart Questions Brent E Excel Discussion (Misc queries) 0 May 9th 05 11:01 PM


All times are GMT +1. The time now is 06:12 PM.

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

About Us

"It's about Microsoft Excel"