How can I show data under a Chart that I inserted in a worksheet?

K

Kimo

I have a worksheet with a Chart over the data ranges. I would like to show
the data under the Chart, so that when it is all said and done, I am showing
a graph representation of the data superimposed over the data.
 
A

Andy Pope

Hi,

You need to set the ChartArea Area to None.
Double click the chart to display the format dialog. And then on the
Pattern tab set the Area to none. Note the chart will not become see
thru until you select a cell and deselect the chart

Cheers
Andy
 

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

Possible to Combine reports to's to a single box? 0
Creating a Chart on form from selected data in query. 0
Overlay line graph points on bar graph 1
Embed the same Excel multiple times 0
Move Chart with Text 0
Excel 2007 charts: want to avoid zero values 1
how to copy XY charts into new worksheet? 1
Superimpose one chart on another 1

Top