Charts
in [Excel]
|
Can you choose direction on the radar chart? Hi! I've a question about the radar chart. Is there any way that you can choose if the chart should be plotted clockwise or anti-clockwise? Thanks! ... 2 Jul 2008 08:48
How to change bar to line in line-column on 2 axes chart in Excel2 I have 3 series of data - Qty, TAT & Target. I would like Qty to be bar while other 2 to be line on seperate axes. When I select custom type line-column on 2 axes, it will give me Qty & TAT as bar while Target as line. How do I change TAT to line? ... 2 Jul 2008 03:42
Chart displaying "blank" cells? In Excel 2007, I would like my chart to not display chart data for empty cells. On the "Hidden and Empty Cell Settings" I have "Show empty cells as: Gaps". I can't seem to get this to work, but my cells aren't empty perse. They return a formula value: =IF(<condition>=0,"",<formula>) The cells that are bein... 15 Jul 2008 07:09
Chart Help Does anyone know how to combine a line bar bar graph with a stacked bar graph? Basically the graph would have 4 bars and then the 5th bar would be a stacked bar while the rest of the bars remain solid. Here is a link to a picture I posted on the UK forums. So far everyone has told me it is impossible, but I ... 2 Jul 2008 21:10
Edit Chart to Change Source Data Background: A decade-plus ago, Excel would allow you to create a chart (based upon cell data), then allow you to select a datapoint in the chart, and literally drag the datapoint, resulting in a change to the cell data value. This was great for visually doing 'what if' examinations (a poor man's method of NOT... 2 Jul 2008 02:41
Automatically vary range in graph depending on #rows data entered? I want to set up a chart so that the range of values entered in the Source Data dialog box automatically changes depending on a count of the number of rows of data that has been pasted into worksheet of source data. Can I embed a link to a cell with the number representing the number of rows. For example, in... 2 Jul 2008 00:39
Hiding Pie Slice When Value is Zero Have you tried setting the format to Custom, with '0%;;;' (three semicolons following the formatting)? This is for the data labels only and will hide the 0% values you are referring to. I am having a similar issue that I cannot solve. I am trying to keep data labels that have blank values from showing up in t... 1 Jul 2008 21:35
Variable Axis Length Hi, since I got help on here last time, I was wondering if anyone could help with this problem... I have built a spreadsheet to show trends in our results. The macro runs through selecting the relevant data, sorting then filtering it and then building a graph to show the trends. As the number of results used i... 1 Jul 2008 15:25
Conditional Formatting - Apply to Charts? Is it possible to apply conditional formatting from spreadsheet cells to a chart? I have a set of scores formatted in RED-YELLOW-GREEN fashion, like a stop light. I would like to show these color ranges in the chart in the grid area. ... 1 Jul 2008 14:24
Use percentages instead of values I have a series of numbers that show how a hard drives space is being used. The table shows the figures in GB values. How do I get a pie chart based on the table to show the % per section and not the GB value? ... 2 Jul 2008 23:13 |