chart axis values

I'm tracking the daily productivity for over 300 employees and 250 working days. Currently, the date/working day is the Legend Entry (Series) and the employee name is the Horizontal (Category) Axis Label. I need a way to switch them around so that the date/working day will be the Horizontal...

Dear Excel gurus, I really need some help with Excel xy scatter charts. I need to edit the X Axis values/scale to reflect ONLY values that are charted, instead of a generic range. For example... I have a scatter chart tied to an Excel worksheet, with a data source that contains 4 Series. The...

I am trying to make a dashboard. I need a chart that on the x-axis maintains a fixed number of values like 20. Let me explain. The source data will be a table in another separate spreadsheet_1 file. What I am trying to do is have only the last 20 values get charted on spreadsheet_2. For...

Hi all, I am having trouble with a simple bar chart... Its for keywords and has three columns:- keyword, average monthly visits, competition. The graph shows the keyword on the left (horizontal category axis labels) and then a horizontal bar chart showing the average monthly visits (numerical...

Hi everyone, I currently have a ton of names defined as a range of "offset" that chart the newest data on a graph and it works great. The only issue is that the last dates are different for each series and they do no change at a constant speed. For example, I have Monthly sales, updated...

Okay, so I have a bar chart I've created whose data source is a range of cells (Progress!$L$4:$Q$6). The category labels (horizontal axis) of the chart USED to reflect the category names as text values (nameA, nameB, nameC, nameD, and nameE), which is what they were supposed to do. I should...

I am attempting to replicate the chart as seen on page 23 of the JP Morgan Chase earnings release for the financial institution I work for. I am struggling to make it work. I will be happy to send the Excel file if requested. My data is layed out as follows: Column A - Date Column B - Total...

My chart axis includes dates from 8/1/12 to current, right to left. My data is chartiing for all dates, but it is not aligned with the dates on the axis; i.e. my data for 8/1 is aligned to the 8/22 date. I have checked and rechecked all the data references, and all seem to be ok. Any ideas?

Using Excel 2007. My X axis is picking up dates from my spreadsheet to chart corresponding $ amounts. The spreadsheet has a daily date in every 5th column that is being charted. Each day new columns are added to cols E thru H, and the new date is then calculated in Col E (=J+1). The older dates...

I have a chart that is set to dynamically update to reflect the last two years of data from a data table. The updating is accomplished through OFFSET and COUNT formulas saved in Named Ranges. The chart depicts percentages as the data and on the Y axis and months/years on the X axis, plotting the...

Hi, I am trying to plot multiple tables on the same line chart in Excel 2007. I have a list of X and Y values for Table 1, Table 2, Table 3 etc. However the size of the tables are not the same for each table. For example, Table 1 might have 200 X and Y values, Table 2 might have 175 X and Y...

After open Excel 2003 sheets with charts and saving in 2010, losts all titles, axes definitions and legend and any other descriptions using fonts are all compressed into 1 space. Any idea what's going on?

Hi, I have a few teams working for me and each team resolves tickets (Alpha, Bravo and Charlie let's say). I want to create a pie chart to compare the teams so each segment is a sum of the numbers. I can do a chart for the individual people. I can do a chart for each team that picks a person...

Hi all, So i have managed this before but can not get it today. I have a named range Chart_Updater and this contains the details of the data rows for charts, Chart_Updater = Worksheets("Sorts").Range("Chart_Updater") For i = 1 To 1 x = thismonth Set SourceSheet = Worksheets("Data")...

Hello, I am working with the following table: <TABLE style="WIDTH: 96pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=128 x:str><COLGROUP><COL style="WIDTH: 48pt" span=2 width=64><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT...

Is there a way in VBA to do the equivalent of pushing the 'Switch Row/Column' button seen in the Excel 2007 chart wizard when selecting the data range for a chart? Essentially my chart data range is correct but the x and y axis values are backwards. I am trying to avoid having to write...