Yes, calling it a Bar Chart wasn't a correct way of explaining. I meant a Progress type bar, where the 52 week low is on the far left, and the 52 week high on the far right. And the current Price listed in its correct area along the progress bar. Ideally it would be great to have it in a Cell. Here is an example from an App. Sorry for the large image, it wouldn't allow me to upload a cropped image.
You mean something like this?
The formulas in the table:
B2: =STOCK($A2,6)
C2: =D2−B2
D2: =STOCK($A2,5)
B3: =STOCK($A3,12)
C3: =D3−B3
D3: =STOCK($A3,11)
The chart is '2D Stacked Bar' with 'Plot Columns as Series' selected lower left. I set the fill on the first and third series to 'None' leaving only the second series (the calculated difference between the high and the low) visible.
SG
That is really close! I recreated your chart, but I'm still left with some problems. One is that it takes 2 rows up, and I have way to many stocks to list. Second problem (and this isn't just your chart) is that I copied and pasted the chart into a Cell, but once I do it turns it into an Image. At least from what I can tell.
Your solution would be fine if I didn't have such a long list of stocks to chart. Also I need to figure out how to get a chart into a cell, and update in real time.
Thanks for the help, if all of you have anymore ideas, I'd appreciate it.
This is a bar chart:
That probably is not what you want. What kind of chart are you trying to do?
SG
I can't think of a way to generate the charts based on only one row of data in a table.
And I don't think there is a way in Numbers to have a chart "move with" cells, the way you can in Excel.
SG
52 Week Stock Bar Chart
