can I add another type of graph on top of my colums

T

Theresa

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?
 
B

Bernard Liengme

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function help: Reference cell based on another cell's value? 3
specifing colors in an excel chart 2
Pivot Table Calculations 0
Unclear change tracking process 0
different colors for bars in a column chart 2
Dynamic (?) chart 0
Advice on creating custom excel program 0
Creating a Pivot Chart 0

Top