| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How can I show data under a Chart that I inserted in a worksheet?
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. |
|
#2
|
|||
|
|||
|
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 Kimo wrote: 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. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with data not getting plotted | Excel Discussion (Misc queries) | |||
| Help with data not getting plotted | Charts and Charting in Excel | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
| changing proportion of chart and data table | Charts and Charting in Excel | |||
| Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel | |||
Linear Mode
