Mr Excel & excelisfun Trick 21: Excel 2010 Sparklines (Amazing Cell Charts!!)

Hi,

I couldn't figure out how to display Sparkline from non-consecutive cells.

I want to display it from two apart ranges: A1:C1 and F1: J1

If it can't be done within the worksheet - is there a VBA code to workaround - such as filling-in an Array from the non-consecutive and using that Array as the Sparkline source ?

Thanks, Elm

Hi,
I saw EXCELISFUN TRICK 369. I need to do something similar. I tried to follow his code and couldn't. Then I tried copying it and growing his records and still couldn't get it to work.

What I am trying to do is on the first list use an inventory list. Which could be about 2000 - 5000 records or maybe double that (not sure how big of a list I could use in Excel). But lets say it is the max number (if someone could tell me that number I would be most appreciative).

I then will load a second list, or would load a list into second column. I then want the difference (what is missing) from the second list to appear in the third list. If it can give me the row of where it is in the first list that would be great (not a problem if you can't). I just don't know why the code from that video is not working any help would be greatly aprreciated?

Thanks,

Peter Fraga
(fragapete@hotmail.com)

Hi people!,
I-ve just dlded office 2010 and tried out sparklines with offset but it gives me everytime the next warning Data source reference is not valid
and the reference is valid cause i used in other charts.

thanks

Respected,
I am not able to create sparklines in excel 2010 as the SPARKLINES group is completely disabled.

THANKX IN ADVANCE

Zohar
zoharsb@gmail.com

Hi All,

I was setting up a spreadsheet that was based on the following vid:
http://www.youtube.com/user/ExcelIsF...14/tqCEY5YMyqw

Dynamic sub tables based on a master sheet array formula

The formula in question is:
=IF(ROWS(A$7:A7)>$E$1,"",INDEX('2010Corn'!A$4:A$17,SMALL(IF(Table2[From]=$B$1,ROW(Table2[From])-ROW('2010Corn'!$H$4)+1),ROWS(A$7:A7))))

B1 is the customer I'm looking for, E1 is the count for the customer and the master page is 2010Corn. I have 20 sheets looking to this master page for data. It works great, except for an issue when adding a new line in the master table.

What is happening is when I get to the end of a row, I tab to enter a new line in the table. It takes up to a minute for the cell to change color and for me to regain control of the computer.

I have run a performance trace and while the computer is locked, one of the CPU core's is pegged for the whole time with a processor que of up to 10 items at a time.

My question is...does anyone have any hints how to optimize this formula?

Thanks
Tony

Hi all

easy question for once, has any one used sparklines:

http://www.vertex42.com/ExcelArticles/sparklines.html

i make a lot of dashboards i like the way it displays information within a cell, has anyone had any experience of using this, or even better if anyone knows how to create miniturized bar and pie charts within a cell, i can do small bar charts by using =rept("I",cell ref) to display lines and the concatenate cells and change rotation to display small bar chart but is very long winded

thanks
Tim

I have just upgraded to Office 2010 from Office 2000.

I have a model created in Excel 2000, where it works fine, but on opening the model in Excel 2010, I have encountered a problem.

One worksheet contains a title in the top left cell; another title in the top right cell, and six separate, equal sized charts filling the space below. I am in Page Break preview mode, and the page setup is landscape.

The sheet displays correctly in this mode with the titles correctly positioned, and my 6 charts effectively filling the remaining space. But when I try to print it (or look at print preview), the titles are correctly positioned at the top of the page, but my charts have not rescaled as I would expect.

In the area of the page where I expect to see 6 charts, I actually have the whole of the top left and the middle left chart; about 1/3 of the top right and middle right chart; and a tiny sliver of the top of the bottom left chart, and a tiny sliver of the top of the the left hand third of the bottom right chart (!).

So my background cells (the titles) appear to be in the expected places, but my charts haven't automatically scaled.

Can anyone help me with the setting I need to restore this functionality in Excel 2010?

Thanks in advance.

Neil

Just This Video For Fun

http://www.youtube.com/watch?v=0VvjrldlqI0

Hi

I am using Excel 2010 and i have created chart and i want to change the labels on the horizontal axis so they face downwards like:

o t t
n w h
e o r
e
e

I hope this makes sense. Does anyone know how to do this?

Thanks

Jeskit

I have just upgraded from MS Office 2003 to Office 2010 at work.
I have 2 problems with graphs in existing workbooks:

1. A worksheet with data and a graph will not print if the graph is in the print range. printing the graph alone also does not work. The network printer appears to get a signal and starts but doesn't print anything. Another graph in the same workbook prints as normal.

2. Upon loading a workbook created in Excel 2003, I got a red error ribbon "Protected View", proceeded to click on "Edit Anyway", got a yellow "Security Warning" ribbon and clicked on "Enable Content" to make the workbook a "Trusted Document". The workbook looks OK but all graphs have disappeared. By clicking on the area where they were, I can see there is a window there, but it has no content.

These errors occur in two separate workbooks, whereas other similar workbooks have no problems with graphs at all.