Recent content by wsnyder

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

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

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

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

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

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

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

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

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

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

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

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

Thanks Hui That did the job Thanks Winston

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

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