legend

I have created bar graphs from pivot tables and inserted them as separate worksheets (in excel 2003). I want to change the size of the plot area and move the legend. When I hide PivotChart field buttons and click on plot area the double sided arrow appears when I mouse over the black boxes on...

I have a Excel stacked table. It actually has three bars but the third is a total of the first two so I have it as zero in the table and just have the data label at the top to display the total of the first two bars. My problem is that I can't get the proper title on the Legend. I need the first...

Hi, I need to create a pie chart with 31 categories and most of them are realy small relatively to others. Can I have the values of all the categories be next to the legend somehow? Thanks, Tamir :-)

I have a calls capacity excel macro that generates a report depending on a shift. The report is a chart that is generated via the following code: ActiveSheet.Shapes.AddChart.Select ActiveChart.SetSourceData Source:=Range(Cells(2, 1), Cells(6, crumbles)) ActiveChart.ChartType =...

Hi all, Firstly, thanks for having this forum dedicated to Excel. I've searched around this forum, and via google, and haven't been able to find out if what I want to do is actually possible. Let's start with the first graph on this page, as it's a perfect example of what I'm dealing with...

Hi, I have calculated data (the column and row headings are calculated as well) similar to this for which I need to create an automatically updating chart. <script language="JavaScript" src="http://www.interq.or.jp/sun/puremis/colo/popup.js"></script><center><table align="center"...

I am attempting to "hide" the data connector line between two individual points by selecting the NONE option in the Format Data Point Pane. Like this: <!--[if gte vml 1]><v:shapetype id="_x0000_t75" coordsize="21600,21600" o:spt="75" o:preferrelative="t" path="m@4@5l@4@11@9@11@9@5xe"...