Tag Info

New answers tagged

0

This is possible -- see https://discussions.apple.com/thread/6894760 You create a source column with each of your options in a cell, select them and format as a pop up. You can then copy and paste a single cell from this region to get a cell which is a pop up containing these values. If you edit a value in the source column you need to repeat the copy and ...


3

You were not able to get Excel to do this for you? The only thing I was not able to do was to get the Horizontal labels centered underneath the columns, but you could likely do it by hand if you hid the column labels then manually typed them into the axis label instead. This is how I got to the picture above. Highlight A1 to N3 and then select Stacked ...


2

You would use a formula for this. In the cell you want the SUM to display (BG1 in your question), enter this formula =SUM(I1,O1,U1) Note that the function is SUM() preceded by an equal sign = and the cell values are comma separated. You can also include ranges by putting a colon between cells. Say you wanted to select A1 through E1, then I1, O1, and U1: ...


0

Add a chart, I used this one: Then click [Add Chart Data] and select the columns for the data streams


0

Taken from this post by Andy Taylor Apple Script snippet do shell script "date +%Y-%m-%d\\ %H:%M\\ Open Automator.app Create a new Service Set it to receive selected text in any application Check the ‘Output replaces selected text’ tick-box Insert the ‘Run AppleScript’ action Copy and paste the above AppleScript Press run ...


0

I know this is a bit obvious but you could try Google Sheets. It's scriptable in server-side JavaScript so if it doesn't do charts like that (and I don't think it does) then you might be able to hack in a solution.


0

Thanks to your sample file, I think I was able to do what you wished. Using an additional column to bring in the numbers corresponding to the codes (16AA, 1; 16AE, 2...) sorting by that column then hiding it the desired result was accomplished. To refresh the sort after adding data, unhide the column and sort again. Here are the steps: Create new column ...


2

EDIT (Complete revision): Based on your data, the only way to accomplish this without redesigning the table is to create separate charts for each Segment shown. As each segment has 4 pieces of data, this is the only way to do this. (There may be someone out there who is a charting expert that could do much better, I'm sure) First, as you have done is to ...



Top 50 recent answers are included