Charts
in [Excel]
|
Source data - have X and Y values for 1 series Someone before me had created a chart with columns and a line, but what I can't figure out is how they made the line the way it is. When I go to the Source Data the data series for the line has both an "X Values" and a "Y Values". When I try to duplicate this in a new chart I only have the option to enter X Val... 12 Mar 2010 08:19
Drawing a line on a chart Help! I need to draw a line on a chart that is horizontal - - in old Excel, the SHIFT key could be used to "snap to" the horizontal, but in Excel 2007, it does not work and it is driving me crazy! ... 12 Mar 2010 08:19
how do I stop excell graphing no data as a 'zero' result? my line keeps bouncing back to zero instead of showing a gap ... 12 Mar 2010 08:19
How to set the bar with same X-axis value in same colour? I have a bar chart showing each team's values. Total have "A, B, C, D" 4 teams. 2 teams each day. Listed in X-Axis are date and team. eg. 1 Jan A, 1 Jan B, 2 Jan C, 2 Jan D. How to set the bar's colour to be the same to individual team? Please advise! FYI, i'm using MS Office 2007. ... 10 Mar 2010 01:59
Excel corrupts charts. How do I stop this? After saving my work in an Excel 2007 file (that has multiple charts) and closing it, the chart formatting is corrupted and I have to resize all the fields every time I open up the file. How do I keep the chart from getting resize within the specified size of the chart? ... 9 Mar 2010 10:04
Excel line chart How do I reduce the white chart area without reducing chart size? ... 9 Mar 2010 12:22
Number and % on same chart A+B= x I want to show: -In one stacked column, I want to show (A+B) and in the same chart in a line form I want to show how much percentage is B. How can I do this? Thanks! ... 12 Mar 2010 09:26
Pivot table & chart problem, How to show different subtotal levels I think you meant to write : He wants to have the both levels of subtotals in the PT, BUT ONLY THE STATE SUBTOTALS IN THE CHART That way your question makes more sense, even if I don't have the answer. :) ... 9 Mar 2010 06:45
Pivot table chart problem, How to show different subtotal levels Hi, Using Excel 2003, I have a pivot table using external data via ODBC. I have a chart based on my pivot table. The table and chart are working correctly. The PTcontains two levels of sales subtotals 1st level is by county 2nd level is by state. My client is telling me that the data in the chart is... 12 Mar 2010 09:26
Stacked and Single Column on the same axis Can I get a stacked column and a Single Column on the same axis within one chart. When I select Stacked for the series it appears to stack all the data on the same column. I am using the secondary axis to plot some line data. ... 8 Mar 2010 13:04 |