ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel graphs (https://www.excelbanter.com/excel-discussion-misc-queries/108543-excel-graphs.html)

Bob

Excel graphs
 
Hi Folks, when using the excel bar and line graph option, good old
Excel seems to choose which column/row has the bar or line, how do I
over ride this or choose myself?? or is this a 'feature' of Excel.
Ta


Bernard Liengme

Excel graphs
 
Make a Column chart first. Now right click a data series on the chart,
select Chart Type and make it Line. Now you get to be boss!
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Bob" wrote in message
oups.com...
Hi Folks, when using the excel bar and line graph option, good old
Excel seems to choose which column/row has the bar or line, how do I
over ride this or choose myself?? or is this a 'feature' of Excel.
Ta





All times are GMT +1. The time now is 02:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com