View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
HEK HEK is offline
external usenet poster
 
Posts: 46
Default Including data in data table but not charting as a series or point

Hi:
One option is to can make the data series for YTD invisible by choosing the
same colours for the data as for the background.
HTH,
Henk

"pepper76" wrote:

I need to chart monthly totals including YTD. When I include YTD in the data
table, then the wizard also charts YTD totals as a series or point. How can
I see the YTD totals in the data table but NOT include it in the charting of
my other monthly totals from the data table?