Luke, I tried working with your dummy idea and had my resident Excel guru take a crack at it, too, but we just couldn't make it behave. When you have a minute, would you work up a dummy file and post it so that I can see how it works, please? Since I work in the research and analytics...
Thanks, Luke, for both the sticky note link and the suggestion. I will check out your suggestion using dummy data but, in the meantime, here is link to the sample chart I uploaded. It is MS Word 2010: http://speedy.sh/djTK9/For-Chandoo.doc
Thanks again,
Kate
Faseeh, thank you for your reply but, Montrey is correct - a line really won't show what I need to show since it is a point-in-time, not a progression.
Montrey, I have a sample file but don't know how to post it here. I'm positive I saw something about posting files but I can't seem to find...
I uploaded my image and email to Gravatar. When I checked the avatar, I got a long link that looks very like the "md5 encode" that I was told to achieve. However, what now? If this is the correct hashed email, what do I do with it? They lost me at Step 3: "md5 hash the final string". :-)
Kate
Thank you so much, Narayan, this was very helpful. I guess I just asked Excel the wrong question because I did not get to that very wonderful information. I've bookmarked it now, though, because I'm sure I'll need it again.
Thanks again,
Kate
I need to create a chart in Excel 2010 that shows the average number of credits students have attempted, the avg number attained, and the success rate as a %. The first two items are just plain numbers usually in the 5.1 to 10.2 range. However, the success rate is a % more like 84%...
I am creating some VIP charts. The company standard is the default red/green/blue/purple Excel colors. That works fine for most of my charting but I need to create a bar chart with only one measure - % of completion. However, I want to highlight the high and low counts by using the default...
Kate from Dayton, OH, here. Retired 2 yrs ago as Business Intelligence Systems Analyst; now back as Admin Asst. Much less pressure. ;-) In my new position, I report to Director of Research, Analytics and Reporting and seem to be continually creating Word docs with Excel charts. I've...