When building charts in Excel 97, many users reference information in other workbooks to keep spreadsheets fairly streamlined. But what do you do if a user complains that the data source has become corrupted or that the file is no longer available in the network?
It's a little bit of a headache to read, but Knowledge Base article 137016 includes the full contents of a macro that can strip important data from the graphic elements of a chart.
After creating the simple VBA macro, you only need to run it and drop the information into a worksheet called Chart Data. Don't go volunteering this information to all of your users, but if a VP loses an important sales worksheet, you can pull out this nifty power trick and save the day.
Shifting a scatter chart's axis
In most cases, Excel's default behavior of making the x-axis and y-axis of scatter charts intersect at 0 is desirable. But sometimes, your users may want to change that intersection point. An obvious example is when a user needs to highlight just a selected number of years of data but doesn't want to create an entirely new chart.
To reset an axis, follow these steps:
1. Activate the chart for editing.
2. Click to select the axis you want to modify.
3. Choose Selected Axis from the Format menu.
4. Select the Scale tab.
5. Type a number in the Value (X or Y) Axis Crosses At text box.
6. Click OK.
Map your data—on real maps
If you often analyze geographically based data in Excel, you should check out Microsoft MapPoint 2000. MapPoint lets you create customized maps, and you can arrange your data on a map to suit your needs. For example, MapPoint can show average household income demographic data (which is built into MapPoint) and then show your company sales data for the same regions. This can help you see trends in how your organization sells across demographic groups. You can save these maps, annotate them, and use them later.
If your organization tracks anything by region, city, etc., take a look at MapPoint. It's also a great general-purpose mapping application that will let you create maps for your Windows CE devices using Microsoft Pocket Streets.
--
Posted By Blogger to Tips for Computer at 2/20/2012 01:29:00 AM --
You received this message because you are subscribed to the Google Groups "Virtual University of Pakistan" group.
To post to this group, send email to discussion_vu@googlegroups.com.
To unsubscribe from this group, send email to discussion_vu+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/discussion_vu?hl=en.
No comments:
Post a Comment