• 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

    Thanks Hui, I guess I need to create a troubleshooting checklist I use the arrow keys to cycle through the chart elements all the time In this case, I did not even think of it. Thanks for the reminder Kind regards, Winston
  2. W

    Cannot locate series on chart to convert chart type

    Hi all, After plotting the first set of data as scatter plot with line I was formatting and removing markers So when I was adding the additional series I could not see the values at 25,25,25 as there was no line and the markers were set to none After many hours of trying many different...
  3. 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...
  4. W

    In Cell Chart Proportionality And Compelling Visual

    Hi all, Did some more research Found a post here at Chandoo.org http://tinyurl.com/23m2oup "How to Visualize Survey Results using Incell Panel Charts" In the comments to the post, David Hager gives us this formula for scaling in-cell charts...
  5. 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...
  6. W

    Stop Proportionatly Scaling Bar Graph

    Thanks Hui, I did that, my only concern that the data will change every week. 150K Max will work for the current week but the possible range of values is +/- $M's Is there no other workaround? Or do I need some VBA to get Large/Small value each week to reset Any thoughts on how I could...
  7. W

    Stop Proportionatly Scaling Bar Graph

    Thanks Hui The 3 items you point out all check out fine X Axis is deleted I also played around with "How To Visualize Survey Results Using Incell Panel Charts" But I'm not sure how to make that work doe to extreme range of values ($M's to Neg $K's) I posted the workbook on skydrive...
  8. W

    Stop Proportionatly Scaling Bar Graph

    Thanks TessaES, I created a new bar chart I changed all X Axis options to "fixed" I also tried changing Max value to 140 as my highes value is 140 but Excel seet the Max Value as 160. But what happenjs next week is my max value is greater than 140? I also still have a problem with the...
  9. W

    Stop Proportionatly Scaling Bar Graph

    Thanks guys, Maybe I'm missing something? As I I select the plot area handle in the middle right and move to the left the plot area and corresponding data bar graph are "downsized" proportionately right to left. I am definitely selected on the plot area and it is confirmed as I hover with...
  10. 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...
  11. W

    Chart Merged Cells

    Thanks Hui, That gave a mountain peak valley view of the graph The option that gives the correct interpretation of the data is Show Empty Cells As "Connect Data Points With Line" Thanks for pointing me in the right direction -winston
  12. 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...
  13. W

    Align Data Bars To Cells

    Thanks Hui That did the job Thanks Winston
  14. 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...
  15. 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...
  16. W

    Recreate Panel Chart Excel 2003 To Excel 2007

    Hui, Dan - Thanks for your help. A few changes from the Excel 2003 instructions But in the end looks great and is 1 chart area as opposed to 3 chart areas placed side by side to look like a panel chart Still some oddities 1.) A secondary axis was added which I deleted, but if you click on...
  17. 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...
  18. W

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

    Thanks Hui, I'll practice your instructions on a copy of the dashboard until I completely comprehend and leave the original dashboard as is for now Looking at it again, I agree, I think it looks ok. Besides, let's me reduce the "Fiddle Factor" which is always a good thing Thanks Winston
  19. 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...
  20. W

    Display X-Axis at bottom of Chart Area

    Thanks Hui I ended up having to enter the min manually to force the X Axis to the bottom of the chart area Is there an option in Excel 2007 so that I can still auto scale yet force the X Axis to the bottom of the chart area? VBA Option perhaps? Thanks Winston
  21. 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...
  22. W

    Sales Dashboard Tutorial

    Thanks all, That respolved my issue. I did modify the formula slightly to remove the pcnt symbol from the concatenation as well as display only 1 decimal place instead of 2. IMO I think both of these factors give us a cleaner display to understand. I also changed the font to Calibri 10 pt -...
  23. W

    Sales Dashboard Tutorial

    Thanks HUI, That works. First thing I notice, you are using char numbers (112, 113, 116, 117), I was attempting to use (129, 130, 131, 132) - slightly smaller, but same appearance. Secondly, your example uses a single font in a cell, the example dashboard is using a mix of arial for the...
  24. W

    Sales Dashboard Tutorial

    Thanks Hui I typed some text into a random cell pre-formatted Calibri 11pt I selected the cell and changed the font to Wingding 3 - all appeared correct Here is what I typed "azsxdcfv". Of course it appears as symbols in the cell formatted with Wingding 3, but in the formula bar the textt...
  25. 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