Slickdeals is community-supported.  We may get paid by brands or deals, including promoted items.
8 results found matching
RSS
Filtering Options
Show results for
$ - $
Filters
Filters
Filters
Excel - fix plot area dimensions
Thread created 10-21-2011 by Dr. J
0 Score 7 Replies 21,250 Views
Post #44083666 added 10-24-2011 12:34 PM by Dr. J in Tech Support
I've done cell linking to axis SCALING via VBA before but this is a different issue.
Excel - fix plot area dimensions
Thread created 10-21-2011 by Dr. J
0 Score 7 Replies 21,250 Views
Post #44080600 added 10-24-2011 11:00 AM by Putz1103 in Tech Support
Try this out: http://peltiertech.com/Excel/Charts/AxisScaleLinkToSheet.html I tried to do it without a macro, but couldn't get excel to do what I want. With the macro on that web page you fix...
Excel - fix plot area dimensions
Thread created 10-21-2011 by Dr. J
0 Score 7 Replies 21,250 Views
Post #44079704 added 10-24-2011 10:33 AM by Jcaelum in Tech Support
hmmm thats weird because i tried it in my excel (2007), starting with y-axis numbers that were 3 digits and then changing to be 4 digit numbers. By default excel made the x-axis widths change, but...
Excel - fix plot area dimensions
Thread created 10-21-2011 by Dr. J
0 Score 7 Replies 21,250 Views
Post #44079442 added 10-24-2011 10:24 AM by Dr. J in Tech Support
Changing the y axis units changes the number of digits required to display ticks. Excel autosizes the x axis to accommodate this change. I did think of your idea as well but excel still resizes the...
Excel - fix plot area dimensions
Thread created 10-21-2011 by Dr. J
0 Score 7 Replies 21,250 Views
Post #44079356 added 10-24-2011 10:22 AM by Jcaelum in Tech Support
so your y-axis is changing between PSI and BAR, and when it changes your x-axis intervals get bigger or smaller? Is it because the numbers on the y-axis are getting bigger or smaller? try...
Excel - fix plot area dimensions
Thread created 10-21-2011 by Dr. J
0 Score 7 Replies 21,250 Views
Post #44079038 added 10-24-2011 10:12 AM by Dr. J in Tech Support
can't do that. the chart in question is toggling between PSI and BAR, a factor of ~ 14.
Excel - fix plot area dimensions
Thread created 10-21-2011 by Dr. J
0 Score 7 Replies 21,250 Views
Post #44021736 added 10-21-2011 2:20 PM by Jcaelum in Tech Support
not sure if i 100% understand your question without seeing the actual data/charts, but a perhaps simple solution would be: on your chart, right click on one of the numbers in one of your y-axis ...
Excel - fix plot area dimensions
Thread created 10-21-2011 by Dr. J
0 Score 7 Replies 21,250 Views
Post #44021280 added 10-21-2011 1:59 PM by Dr. J in Tech Support
I am putting together a sales tool in Excel which consists of 3 charts vertically aligned where the x axis are all the same, so you can use a ruler/eye guide to see where the 3 independent parameters...

More Results from Amazon.com See more at Amazon

More Results from Walmart.com See more at Walmart

More Results from Ebay.com

Didn't find what you were looking for?

We're displaying limited results because of the following settings:

  • Deals with Any Rating
  • Deals from Any Time
  • Deals from 24 forums
  • Deals filtered by and
  • Searching within Entire Threads

If you want to relax this search, click here to reset all search parameters. You can also adjust them by using the filtering options on the left.