Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
dual y-axis align grid, drop line to y axis, add-ins
1. Is there a way of scaling two y axis so that the grid lines intersect at
a specified integer on both axes, other than trial-and-error? 2. Other than drawing one, how would one drop a perpendicular line (s)from a plotted line to the y axis? 3. Any recommendations for free and paid (please specify) add-ins for excel 2007 charts? Thanks in a advance, John (SAS programmer who must use excel) |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
dual y-axis align grid, drop line to y axis, add-ins
1. You can adapt the algorithms described in this post:
http://peltiertech.com/Excel/Charts/AlignXon2Ys.html 2. Use an error bar. http://peltiertech.com/Excel/ChartsHowTo/ErrorBars.html http://peltiertech.com/WordPress/err...in-excel-2007/ 3. What kind of added functionality are you in need of? I have released some commercial utilities: http://peltiertech.com/Utility/WaterfallUtility.html * http://peltiertech.com/Utility/BoxPlotUtility.html * http://peltiertech.com/Utility/ClusterStackUtility.html http://peltiertech.com/Utility/MarimekkoUtility.html Maybe I'm biased, but I think they're pretty good, and only one customer out of around 200 has asked for a refund (and the utility didn't work because the customer wouldn't perform a Detect and Repair correction of Excel). The two starred utilities in the list above also have free evaluation versions with somewhat reduced functionality. I also have posted more free utilities than I can remember, but here are some of them: http://peltiertech.com/Excel/ChartsH...rtUtility.html http://peltiertech.com/Excel/Charts/ChgSrsFmla.html http://peltiertech.com/WordPress/enh...art-procedure/ http://peltiertech.com/Excel/Charts/...tCreation.html The commercial utilities all work in Excel 2000 through 2007. The free ones work in 2000 through 2003 and some have been adjusted to work in 2007. In addition to these utilities, I have posted are innumerable examples that show how to manipulate charts with VBA, as well as some VBA tutorials. Start with this tutorial: http://peltiertech.com/WordPress/how...e-elses-macro/ Here are lists of VBA-related content: http://peltiertech.com/WordPress/category/vba/ http://peltiertech.com/Excel/Charts/ChartIndex.html#vba - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "John L" wrote in message ... 1. Is there a way of scaling two y axis so that the grid lines intersect at a specified integer on both axes, other than trial-and-error? 2. Other than drawing one, how would one drop a perpendicular line (s)from a plotted line to the y axis? 3. Any recommendations for free and paid (please specify) add-ins for excel 2007 charts? Thanks in a advance, John (SAS programmer who must use excel) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dual Y Axis in Line Plots | Excel Discussion (Misc queries) | |||
grid on dual y axis graph | Charts and Charting in Excel | |||
how do i add an x-y convergence drop line from y to x axis? | Charts and Charting in Excel | |||
can I make the vertical axis the category axis in Excel line graph | Charts and Charting in Excel | |||
How to insert X axis scale values next to axis and X axis grid lin | Charts and Charting in Excel |