Charts
in [Excel]
|
Charting with irregularly spaced x-axis Hi, create the chart with the XY Scatter chart type, then the X axis will be scaled with the gaps according to the values. With your data sample Column A = Date, column B = Days from start, column C = measurement, set up the XY data series with Series X values =Sheet1!$B$2:$B$5 Series Y values =Sheet1!$C$2:$... 26 Dec 2009 03:36
How can I generate a Tag Cloud of words in Excel? Does anyone know of a plug-in or method to use Excel to generate a 'Tag Cloud' chart / graphic in Excel? I export database records to Excel for detailed analysis using pivot tables, and I'd love to have a way to turn entries in a 'Keyword' field into a tag cloud. Basically this: - Read the contents of a colu... 23 Dec 2009 18:33
Changing Pivot Table Data Source to multiple ranges In Excel 2007, I just ran out of room on a tab that feeds into several pivot tables that feed into other daily and weekly reports. I have found the way to create a pivot table with multiple consolidation ranges, but have not seen any way to edit the data source of an existing pivot table to include another ran... 23 Dec 2009 19:40
How to add another y-axis range into chart? Does anyone have any suggestions on how to add one scale on right y-axis and one scale on left y-axis? Thanks in advance for any suggestions Eric ... 22 Dec 2009 10:23
Secondary axis help Hi everyone, I am having some difficulty in Excel 2007 Charting. I have a stacked bar chart that I would like to add a horizontal secondary axis on. How do I do this? I'm trying to do what the Help says but there is something that I am not getting. 1. I click on the Chart and select the Format Tab 2. In the C... 26 Dec 2009 04:40
Multiple Bar Graphs on one chart I am trying to combine multiple bar graphs onto one chart I am trying to display a bar graph to schedule time at my office. Employees work outside and inside and I would like to display that as 2 different colors. Unfortunately some work inside and then outside, while other work outside and then inside. This ... 19 Dec 2009 14:55
Chart Data Point Size Changing ? Hello, Using Excel 2007 I'm embarrassed to ask this, as it's undoubtedly so simple, but just can't find out how to do it. Everything sure was simple in earlier versions ! Anyway, I have a simple chart that I created, linear, with the data points being shown as squares. Guess it picked the squares on its... 8 Jan 2010 17:20
month count How to set a formula to count the number of month between two dates? example: Jan 5,2009 to Feb 4, 2009 = 1 month Feb 5, 2009 to Apr 6, 2009 = 3 month (round up) ... 18 Dec 2009 15:02
Excel 2007 Have created charts using Excel 2003. Converted to 2007. Now when I select Chart/Print preview the chart doesn't use the whole page. In 2003 under "Page Setup" there was a "Chart" tab - "printed chart size" - "Use full page". That option isn't avail. in 2007. If I "move" chart to it's own sheet then the fonts/... 17 Dec 2009 18:12 |