Charts
in [Excel]
|
How do I move a chart using a macro? Hi, all, I have a nice little macro that creates two charts on several worksheets in a workbook. My problem is that it places one chart right on top of the other. I just need to offset it enough to see both charts, or at least to remind myself that there are two of them there. I tried variations of the ... 27 Jan 2010 09:15
Chart question I am trying to make a chart that shows 2009 numbers versus 2008 numbers and here is my issue: I have 4 cities Chicago(A1), Dallas(A2), Detroit(A3), and Los Angeles(A4) that I have for 2008 and 2009 but I added 2 cities for 2009. Is there a way to do a vlookup to pull the data for the chart or do I have to set u... 26 Jan 2010 15:33
XY Charts Excluding Weekends I have a date series where we are tracking sign-ups for a service. * There will be NO sign-ups during weekends. * Multiple people can sign up on one day. I need a chart in Excel 2007 that shows a marker for each sign-up on each day and the chart MUST exclude weekends. I've tried XY and Line charts, but cannot ge... 26 Jan 2010 20:08
Make a calandar chart I want to use excel to make a calendar chart. across the top i want the twelve months. Within each month i would like 4 or 5 columns to represent the weeks. the vertical axis will represent data to be plotted by pencil. the cells will remain blank in excel. In essence i am making a one page piece of graph ... 26 Jan 2010 04:23
NA in Line chart plotting as zero When I'm getting a cell value of #N/A for my IF(VLOOKUP()) statement, it is still plotting as 0:00. Is there a special number format I need to use in order to not plot #N/A as zero? "Jon Peltier" wrote: NA is just text. #N/A is the error that line and XY charts skip when plotting markers. - Jon ... 25 Jan 2010 15:07
Crossing to New Year in Source Data I have a chart based on attendance for the school year. It goes from 9/09 to 6/10. I have my data source chosen for the entire time frame, but the chart is only showing information until the end of 09 and won't continue into the new year. I have date labels on the bottom of the chart. Any ideas? ... 25 Jan 2010 16:15
Want previous years data to drop off as I enter current year d I am working in Excel 2003. I still searched for dynamic range but it's not making sense. Any explanation would be appreciated. "trip_to_tokyo" wrote: In EXCEL 2007 type:- dynamic range - into the F1 Serch facility. In the topics that are shown there is an item called:- Update ... 3 Feb 2010 11:44
From OP: Re: Axis Numbering Question Hello, Just a quick thanks. Bob --------------------------------------------- On 1/23/2010 7:58 PM, Bob wrote: Hello, Using Excel 2007 and Windows 7. Let's say I have a chart with vertical axis tick marks every 10 units. However, my grid lines are every 20 Units, and the number for the... 24 Jan 2010 20:22
Swapping headers Is there a way to swap the column and row names so that I can click/drag ascending nunbers horizontally and letters vertically? ... 25 Jan 2010 13:58
Dynamically Scale Gantt Chart Time Scale Excel 2007 (or 2010 Beta, if that's the only way to do it) I've developed a Gantt Chart using a stacked bar chart. It works great. Is there any way to have the horizontal axis (or vertical axis, I get confused with the terms in a stacked bar chart) expand in and out based on the MIN and MAX of the dates in... 2 Feb 2010 17:27 |