chart axis values

  1. F

    Is there any way to exceed the maximum # of data series per chart?

    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...
  2. T

    Excel Scatter Chart - X Axis Tick Marker Values

    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...
  3. L

    Dynamic Chart of fixed number on one axis

    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...
  4. G

    Add Column to Bar chart as Labels

    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...
  5. E

    Chart Date X-axis help

    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...
  6. Z

    Chart Category (Horizontal) Axis Labels Stuck As Numbers

    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...
  7. J

    Multiple Axis & Chart Type in Single Chart

    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...
  8. cvincent

    Series Data Does Not Align with Axis - Excel 2007 Graph

    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?
  9. cvincent

    Chart x axis data selection

    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...
  10. D

    Chart point formatting based on axis label value

    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...
  11. X

    Multiple data tables on a single graph

    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...
  12. K

    Chart issue converting from 2003 to 2010

    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?
  13. J

    Pie Chart Individual Sums

    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...
  14. Z

    Updating charts using Named ranges

    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")...
  15. I

    Excel 2003 Charting - X-axis Values across range

    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...
  16. N

    VBA Chart Switch Row/Column Help

    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...

Some videos you may like

This Week's Hot Topics