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