ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   can I add another type of graph on top of my colums (https://www.excelbanter.com/charts-charting-excel/223241-can-i-add-another-type-graph-top-my-colums.html)

Theresa

can I add another type of graph on top of my colums
 
I have 2007,2008 electric bills in colums, rows are cost. I would like to
add the average temperature for 2007-2008 in the form of dots with the
temperature showing is that possibel?
--
Theresa

Bernard Liengme[_3_]

can I add another type of graph on top of my colums
 
Select and Copy the new data
Click the chart to activate it
Use Edit | Paste Special specifying New Series; depending what you Copied
you may need to specify "First column has x-values" and "top cells have
labels" -- not the exact words but close!
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Theresa" wrote in message
...
I have 2007,2008 electric bills in colums, rows are cost. I would like to
add the average temperature for 2007-2008 in the form of dots with the
temperature showing is that possibel?
--
Theresa





All times are GMT +1. The time now is 08:15 PM.

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