|
Scatter Diagrams The x values will not display properly. They just plot as if they were the numbers 1 2 3 etc but the y values are fine. If I make the reverse the x and y data the graph works but is of course not in the format I want Suggestions please ... 4 Jul 2008 14:07
charts and pivot tables I update a table in excel (2003) each month, showing year to date data. I need to pivot the data into many pivot tables then create charts (I don't want to use a pivot chart for cosmetic reasons). Because it is year to date, I would like the charts to automatically update each time I add a new month (date is on ... 4 Jul 2008 14:07
change source data in multiple charts Hi I have over 30 charts where I need to change the source data and it's taking ages doing it manually, especially as each chart has 3 or 4 series. Is there an easy way of doing this, please? I've tried find and replace, but that doesn;t work Thanks ... 4 Jul 2008 14:07
Dynamic Range I'm trying to automate a table from Access to Excel and generate a line chart in Excel. I have 3 attributes; Week, Target and Actual. Initially 'Week' was a Number type and the automation worked perfectly fine. But recently, I changed 'Week' to Text type and errors occur. First, VBA keeps showing Run-time e... 4 Jul 2008 14:07
Horizontal axis with its real value Hello All, I need to solve my problem that I am going to describe ASAP. Thanks in advance for you help. I want to draw very simple chart let say: A B 1 11 2 12 3 13 20 14 I have the table above. I would like to draw B values by using A values in horizontal axis. When the graph is drawn A values are ... 4 Jul 2008 02:51
Data labels along below x axis when y axis has negative values Hi, I created a stacked column chart where my y axis has values ranging from 700k to -700k. For each column I have a label displayed along the x-axis. However, by default the labes are displayed just below 0 on the x axis (right in the middle of the chart). If a charts scale ranges from 0 to > 0 the labels are... 3 Jul 2008 16:38
======> Secret Video CLIPS <========= Hi....Friends, watch and enjoy SECRET WEB-CAMS at LADIES HOSTELS and INTERNET CAFE SEX SCANDALS VIDEOS... http://www.hollywoodpopstars.blogspot.com http://www.googlemobilesphones.blogspot.com ... 3 Jul 2008 11:28
Dynamic Charts - Changing Number of Series I've read a lot of the entries regarding Dynamic Charts and think I understand it for a single Series, but I'm having trouble getting it to work when it's the number of Series that changes and the Category is static. I'm using a line graph (data sample below) for sales at different locations of dealerships dur... 3 Jul 2008 01:15
Overlapping Time Chart? Is there a way to graph a chart by date (x axis) that shows stacked bars for overlapping time? Ideally, I would have the columns like below: Date ShoppingStart TimeShopping StoreAsStart TimeInStoreA StoreBStart TimeInStoreB 1/1/08 7:00AM ... 4 Jul 2008 14:07
Excel 2007 - Printing graphs with no data or graph lines I am seeing the exact same problem, and we have several hundred charts. Please post if you have made any progress. Anyone else have any ideas or have seen this? "aew20" wrote: Dear group, We have some engineers that have fairly intesive graphs with tons of data points on them. When we open the E... 2 Jul 2008 17:03
2-axis problem with horizontal crossing I have a 2-axis bar/line chart, and the bar values (primary) go from 0 to 18,000, while the secondary goes -4% to 15%. I am having trouble forcing the axes to both cross at a horizontal 0 (which implies that the primary axis would have to either start negative and cross at 0 (not preferred, because logically w... 2 Jul 2008 23:13
changing from days to months I am new to excel. But please have pity and help me. I have a chart that is perfect but I need to be able to change my pivot table/chart from month to month to print out reports and it is stuck on giving me the total year info. Can someone please help. What does my Date need to be labeled as? what axis? ... 4 Jul 2008 11:02
animated / motion / chart Excel Hi, Is there any way to animate animate charts in Excel 2007. I have yearly series (2008, 2009, 2010, 2011) For example I would like that the chart being displayed would change with the year. Is there the possibility to do this inside of Excel? Using a macro (if there's a possibility without a a macro the... 4 Jul 2008 03:52
Changing only Legend Text Is there a way just to change the legend text, without affecting the axis label in Excel 2003? If I go to Source Data, it has one entry for those labels. Thanks, Alan ... 3 Jul 2008 00:14
Excel 2003 - Chart printing squashed... but not always! Hi, was hoping someone might be able to help with this problem. We have a chart with two y axes, which displays fine on screen, and prints fine most of the time... but every now and then it prints squashed vertically. Has anyone else had this problem or have any idea what may be causing it? Many thanks, M... 2 Jul 2008 09:50
Chart type problem I have a problem to create a chart. I have this data: Machine part minute start minute stop G A 0 282 G B 282 359 Ma C 0 298 Mb D 0 183 Mb E 183 497 Pa F 110 278 Pb G 0 172 I want a chart with bars whic... 2 Jul 2008 09:50
bubble size display Dear All, I am plotting some bubble charts in which the series are in the following form: ProductName, NumberParts,NumberVersions,TotalValue The series are being plotted as NumberParts in X axis, NumberVersions Y and TotalValue as the bubble size. I would like to display in my graph the value of the bubbl... 2 Jul 2008 16:01
How to change bar to line in line-column on 2 axes chart in Ex It works. Thanks very much, Shane. "Shane Devenshire" wrote: Hi, Single click the series you want to change and choose Chart, Chart Type and pick the chart type you want. Cheers, Shane "jaysan3" <jaysan3(a)discussions.microsoft.com> wrote in message news:D3D5B6F7-2C85-46F2-8A63-59D... 2 Jul 2008 06:46
Help with series in the chart I have 3 colums 1 = dates 2 = numbers 3 = names I want to have each name on the X axis the dates on the Y axis and then i want to graph the numbers for each date. Please please can anyone help me? ... 2 Jul 2008 09:50 |