I want the chart to display only a portion of the data table with the chart like this:
(only groups show in data table) Instead of this: (groups and control lines show) It doesn't seem like changing the columns to white text is flowing through to the data table that goes with the chart. -Tammy Lubick ________________________________ From: Harmeet Singh [mailto:harmeet.hew...@gmail.com] Sent: Friday, March 20, 2009 9:16 AM To: excel-macros@googlegroups.com Cc: Lubick, Tammy L. Subject: Re: $$Excel-Macros$$ Hi, If I understood right, u don't want legend to be hide. To make data table invisible i just chaged the font colour. See attached file. Let me know if that was stupid. :) On Fri, Mar 20, 2009 at 5:30 PM, Lubick, Tammy L. < tammy.lub...@cunamutual.com> wrote: I have a chart that I would like to be able to display the upper control limit, rolling average and lower control limits as shown in the attachment but I don't want to have this information displayed on the data table. I don't want to put static numbers in the chart because we want to move to a longer term rolling average so the control limits will change over time. The work around I use is to put a white box over the data section (see 2nd chart) I don't want displayed, is there a method I can use to eliminate this manual step? -- Thanks & Regards, Harmeet Singh --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
<<inline: image003.jpg>>
<<inline: image004.jpg>>
