Search results

Montrey - yep, that's a good idea but then it doesn't make the graph look all that clean. I've got values that could never be below 0 so showing below zero on the axis label seems irrelevant. I guess I could do a custom axis and set the -1 value as text to kill the awkwardness. Thanks!

Anyone else have trouble with line graphs interacting with the X-axis? For example, I've got volumes on Y, and time on X. If volume is 0 for one date in time, then the point is on the X axis. If there are two consecutive dates with volume of 0 then the graph line runs across the x axis...

Luke - perfect. Now if only I could get my excel to stop crashing when I try to run this for a few thousand lines...

Luke, Suresh - thnaks fr the notes. Rank is working well except in the case of a tie. =SUMPRODUCT(($C$4:$C$1048576=C4)*($E$4:$E$1048576>E4))-SUMPRODUCT((C4:$C$1048576=C4)*(E4:$E$1048576=E4))+1 I've got a tie value that is resulting like so: Rank, Name, Value 0 Apple 10 1 Apple 8...

I've got two columns: Names and Values. The Names repeat, but the value are all (mostly unique). I want to rank the values, but only against identical names. For example, if I had the following set: Apple 10 Apple 20 Pear 40 Orange 10 The ranking result would return: 2 Apple 1...

Rehashing this one as I've got some more complicated scenarios kicking around. Let's say I've got my data set up in columns, and my dynamic range set up with the following formulas: Spend: =OFFSET('INTERACTIVE I'!$AD$3,1,0,COUNT('INTERACTIVE I'!$AD$3:$AD$42)) Months: =OFFSET(Spend,0,-1)...

Hui - thanks. Can you explain how this should work? I've copied this into the module but it doesn't seem to make any impact.

konijay - understood. I know you can have SAP automatically remove that formatting, but if you cannot... You can create a helper column that will look at all the date cells and use the DATEVALUE function to convert. Choose any column and use the following formula: =Datevalue(A1)...where A1...

konijay - the easy way I would approach it... If your date column is static (meaning you don't need this to work automatically as you add new dates with apostrophes), I would use the Text to Columns tool (found under the data tab) using "Delimited" option to remove the apostrophes from the...

Have challenging one here... Created a file intended to be viewed across multiple screen sizes. The goal is to have this display as full screen as the default. The problem I'm running into is that there really isn't a way for me to format the sheets in a way that is viewed perfectly on every...

Figured it out...needed to finish up the formatting. [>=1000000] $#,##0.0,,"M";[>0] $#,##0.0,"K";0

I have a custom Format Cost for some Y Axis values written as follows: [>=1000000] $#,##0.0,,"M";[>0] $#,##0.0,"K" For some reason, the first value shown (where X/Y axis meet) is displaying in a random color. Even if I format the whole axis to one color or another, it just formats...

Right, can't move charts but other objects work. Snap helps, thanks.

Is there any way (similar to in PowerPoint) to graph a graph in Excel and move/position with the arrow keys? I'm often shifting graphs around for dashboards but have a hard time getting that perfect fit. Any tips welcome!

Works great! Thanks. Can you explain the "Option Explicit" code? I didn't know to include this piece.

SirJB7 - correct, to previous state! The graph loads without labels, the check box will toggle those lables on and off.

I know it's possible, just not sure how to edit my Macro code... I've got a Macro recorded which adds data labels and formats them for a chart when "Checked." How do I edit this so that when I "Uncheck," it reverses the code? I imagine I can do a simple "If True, then X, if False then X"...

Luke - that did it, clever!

Luke - makes sense! Let's expand on this a bit. My data is set up as calculations (unlike our example where the data used is essentially static unless manually changed)that pull from a data source when available. So this dynamic chart works great, however since I've got formulas in my data...

Luke - exactly. I've tried changing the labels to various titles as well with no luck. The part that isn't working is when I hit enter after those adjustments to the graph. It gives me the following: "A formula in this worksheet contains one or more invalid references. Verify that your...

Just giving this a friendly bump to see if anyone has any thoughts on why the formula above isn't adjusting for graphing.

Luke - works great with my column data, but to get a better understanding of the formula I am trying to set it up with rows as well. Believe I've got my named ranges set up correctly, but I can't get the graph to go through. Here's what I'm working with: Data is set up running across...

Awesome - I'll need to tweak with my data since it's running as a row but I can easily change. Jordan, you are correct. #N/A is basically what I am working with now. Thanks, Luke!

This one has been haunting me for some time. I am setting up a dashboard (which includes prices and dates) so that when I receive new raw data, my graphs refresh automatically. Thus, I've set up time graphs - think a line chart with the horizontal axis being "Months." Currently (since I only...