• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. W

    Cannot locate series on chart to convert chart type

    Hi all Using Excel 2007 I found this great post for creating Excel 2007 bullet charts over at instantcognition.com http://blog.instantcognition.com/visualization/2007/08/10/creating-bullet-charts-in-excel/ When I look at the chart data dialog, I see series 4 and series 5 listed but I...
  2. W

    In Cell Chart Proportionality And Compelling Visual

    Hi all, Using Excel 2007. I am tring to come up with a way to show values as data bars for several A/R "Types" on a weekly basis. Ive been trying with data bar graph, but due to extremes in values (+/- $M's), may not be possible or at least visually interesting I then came across this...
  3. W

    Stop Proportionatly Scaling Bar Graph

    Hi all Using Excel 2007 I have a Bar Graph As I try to shrink the chart from right to left the end of the data bar moves proportionately away from the right edge of the plot area and the chart area I would simply like to decrease both the chart area and plot area so they are snug to the...
  4. W

    Chart Merged Cells

    Hi all, Using excel 2007 I am trying to create a simple line chart from some data The data updates based on a scroll bar and in in K's (675.4 for ex) It appears as I try to chart that Excel is interpeting one of the merged cells as 0 I converted the chart type becuase initially I could...
  5. W

    Align Data Bars To Cells

    Hi all, Using Excel 2007 I have forumlas that summarize A/R data by Invoice Type I then inserted a data bar chart on the resulting values I tweaked the bar chart and got it looking good Now I'm tring to align the data bar chart to the values so it almost appears that the values are on the...
  6. W

    Plotting large sales ranges on bar graph

    Hi all, Starting a new dashboard I have a large range of sales where 1 unit is 197K and another unit might by 1.3K Due the range of values I am afraid it may not translate meaningfully to a bar graph I've loaded my initial workbook here...
  7. W

    Recreate Panel Chart Excel 2003 To Excel 2007

    Hi all, Using Excel 2007 I found a nice tutorial on Jon Peltier's blog for a panel chart http://peltiertech.com/WordPress/chart-busters-compare-employee-sales/ The instructions appear to be for Excel 2003 or earlier I am trying to make it work in Excel 2007 and stumbling a bit. Before...
  8. W

    Zebra Stripes Dont Appear Correctly When Position X Axis On Tick Marks

    Hi all, Using Excel 2007 I am attamepting to add some zebra stripes to my charts However, they don't look quite right when I clixk on X Axis and select position axis on tick marks so that Series 1 does not appear to be floating How can I satisfy both needs? I uploaded a copy of the...
  9. W

    Display X-Axis at bottom of Chart Area

    Hi all, Using Excel 2007 I charted some values that are a mix of positive and negatives over a span of six years The X-Axis seeme to be displayed in about the middle of the chart with a label ever third tick mark (04, 07, 10 for years) I would prefer to display the X-Axis at the bottom of...
  10. W

    Sales Dashboard Tutorial

    Hi all, Using Excel 2007 I've been using Excel for awhile I didn't realize how poorly I was using it until I came across Chandoo.org So in an effort to correct the error of my ways, I am working through some of the tutorials on the website. For the Sales Dashboard Tutorial, I got the...
Back
Top