Charts
in [Excel]
|
save chart as template I'm trying to save a chart into the chart templates. I've clicked on "Save as Template" but when I go to insert into another document, it won't let me insert it. I have to click on Manage Templates and then click on the template that I saved but when it opens, there is nothing there! Help!! ... 18 Jun 2008 23:03
Progress bar in spreadsheet? I am creating a spreadsheet where I will have a long list of projects. One column represents the completion percentage for the project. I'd like to display this as a progress bar. If the project is 50% complete, I want the left half of the cell to be colored in. If it is 75% complete, I want the left 3/4 of... 19 Jun 2008 05:29
provide value to data series from named range Dear Friends I want to link value of data series to a particular cell value or named range Is it is possible ? Please guide me Ramesh Shetty ... 18 Jun 2008 23:03
Automatically update Value for data label Hello I am using Excel 2003 SP2, and have some graphs which have the value (data label) for the last month. Each month new data is entered and the data label has to be deleted for the previous month and the data label for the most recent month added (it still uses the same old data - new data is only entere... 18 Jun 2008 23:03
Excel 2007 - change interval between labels on X axis I have two layers of labels on the X axis.Top labels are days of the month 1-30 or 31. Under that is the month - May, June etc. I cannot seem to change the interval between labels, to show for example days of the month as 1, 3, 5 ... rather than 1, 2, 3 ... I can change the interval in the Format Axis dialogue box ... 19 Jun 2008 08:33
Dividing a bar in a graph into several sections I have a bar graph that shows sales from several products for each month. Each bar represents one month of total sales. Currently the graph is only displaying the total sales of all products for each month but I would like to display the sales of each individual product within the same bar for each month. Ca... 24 Jun 2008 21:35
Hide Graph of Data Outside X-Axis Range I have an XY Scatter graph with data back into the 1990's (for example, 10-Year US Treasury yields). The graph references all of the data so that when I change the dates on the x-axis (my range of dates I want to view), I don't have to redo the data references. The problem is, the graph of Treasury yields (le... 17 Jun 2008 20:20
Label a chart of counts with other percentage data Here's the data: Group 2005 2006 2007 LTM Data A 19.4% 22.8% 21.2% 19.9% Profitability A 6 7 7 7 Count B 9.5% 31.6% 30.4% 30.7% Profitability B 2 3 3 3 Count C 22.4% 23.6% 16.6% 17.6% Profitability C 15 16 17 18 Count D 19.2% 20.5% 15.9% 13.7% Profitabil... 17 Jun 2008 13:11
Flow Charts in Excel Is there a way to build a Flow Chart in Excel using parent/child relationships? Thanks EM ... 17 Jun 2008 14:13
Charting with Benchmarks I have to create several charts that will identify two things - a 5yr trendline showing their percentages on certain criterial and secondly where they lie against certain benchmarks for the same periode. The benchmarks cannot be stacked columns but dashes or some type of mark. See data below. 200... 17 Jun 2008 12:40 |