Adding Data Table with Goal Line

  • Thread starter Thread starter patxlb
  • Start date Start date
P

patxlb

I have read the tutorials for adding a horizontal/goal line within
chart. However, now I have lost the option to show the data table fo
the original series. Is there any way to show this info?

Thanks
 
Data tables can be a real pain. I find it easier to make a table in the
cells near my chart. This way I can include the data I want and exclude
the data I don't want.

If your chart is a chart sheet, you can't do this, but you can still
make a custom table in a worksheet. Then use the camera tool to copy it
and insert it in the chart.

The camera tool is well hidden, and not present by default anywhere you
can use it. Go to the View menu, Toolbars > Customize, and on the
Commands tab, select Tools on the left, and scroll almost all the way
down the list on the right until you find the Camera button. Drag it to
a convenient place on your toolbars.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top