Thursday, March 31, 2016

Adding series to dynamic bar chart automatically. [Anwsered]

Adding series to dynamic bar chart automatically.

Hi I have a dynamic bar chart set up, basically from the following data starting in cell A1;

Name       Jan       Feb       Mar       Apr       May       Jun       Jul      Aug       Sep      Oct       Nov       Dec
West 1   1001      1050     1100    1150    1200     1250     1300  1350    1400     1450   #N/A      #N/A
West 2    900        960       1120    1280    1340     1400     1460  1520    1580     1640  #N/A      #N/A
                #N/A       #N/A      #N/A     #N/A     #N/A     #N/A     #N/A   #N/A     #N/A     #N/A   #N/A      #N/A
                #N/A       #N/A      #N/A     #N/A     #N/A     #N/A     #N/A   #N/A     #N/A     #N/A   #N/A      #N/A
                #N/A       #N/A      #N/A     #N/A     #N/A     #N/A     #N/A   #N/A     #N/A     #N/A   #N/A      #N/A

The data above is pulled from another sheet, it either pulls in a number, or if there's no value it returns #N/A as I use NA() in the formula.

I have named ranges as follows;

Date =OFFSET(Sheet1!$A$2,0,1,1,COUNT(Sheet1!$2:$2)-0)
Label =OFFSET(Sheet1!$A$1,0,1,1,COUNTA(Sheet1!$1:$1)-1)

This works fine for one series.

What I would like to do, is be able to have this chart automatically add additional series if an additional meter name is added, ie to add  a series 2 for West2 in the data above and so on .
(Names will vary).

But I'm stuck, any nudges would be most apreciated.

Anwsers to the Problem Adding series to dynamic bar chart automatically.

Download Error Fixer (Free)

Hi I managed to answer my own question here,

I changed =OFFSET('Sheet1'!$A$1,1,0,COUNTA('Sheet1'!$A:$A),1)

to =OFFSET('Sheet1'!$A$1,1,0,MATCH("*",'Sheet1'!$A$2:$A$16,-1))

This now ignores the formulas that return " ", if you use this make sure your first cell ie in my case $A$1 returns some think other than a blank or your get formula error warning.


To check for Windows updates. Open Windows Update by clicking the Start button , clicking All Programs, and then clicking Windows Update. In the left pane, click Check for updates, and then wait while Windows looks for the latest updates for your computer. If any updates are found, click Install updates.

Install the latest updates for Windows and for the program displaying the error. Note that the update for the program might be listed as an optional update on the Windows Update page.

Open Windows Update by clicking the Start button Picture of the Start button. In the search box, type Update, and then, in the list of results, click Windows Update.

Another Safe way to Repair the Problem: Adding series to dynamic bar chart automatically.:

How to Fix Adding series to dynamic bar chart automatically. with SmartPCFixer?

1. You can Download Error Fixer here. Install it on your computer. When you open it, it will perform a scan.

2. After the scan is finished, you can see the errors and problems which need to be repaired.

3. The Fixing part is finished, the speed of your computer will be much higher than before and the errors have been removed.

Related: How to Fix - 64g ssd with a 500g regular drive?,Allow Unhide Rows in Protected Workbook [Solved],[Solved] Get in Excel 2007 data from Access 2007 out of self-built Queries,[Solution] How can I temporarily disable 'service manager' to install Adobe flashplayer?,[Anwsered] When I try to watch a flash video, I am told occasionally that I don't have Adobe Flash.,Solution to Error: Black screen during boot sequence,[Solved] Can't restore Windows 7 64-bit from external hard drive,How to Fix - IE 11 Enhance Protect Mode reset issue with add-on's?,Solution to Error: Internet Explorer 9 update/install error - Error Code 80092004,Upgrading to IE 8 causes cookies to get deleted when starting IE [Anwsered],Solution to Problem: All programs try to start from windows component
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,How to Fix Error - Getting an error "not connected to the internet" while trying to install Samsung Kies?
,How to Fix - Internet Explorer shuts down and reopens tab when attaching to email or uploading files.?
,Fast Solution to Problem: Sending Error Message
,[Anwsered] Thinkpad 8611 Boot,How to Resolve - Svchost Helper?,Fast Solution to Problem: L30 101 Driver Windows 7,Troubleshooter of Error: Io Device,How to Fix Error - Dell Laptop Code 39?
Read More: Solution to Error: adding windows mail to Comcast,How to Fix Error - Adobe acrobat serial number?,How to Resolve - After changing the hard drive on my Windows 7 laptop I am unable to recognize my printer and it won't print.?,How to Fix Problem - Adobe 9 Reader and Flash Will Not Download?,after hard drive restarts from sleep mode cursor continually moves across search window without stopping. [Solved],a file called mDNSResponse.exe. is causing bonjour not to operate properly,what should I do?,A QUESTION USING THE "IF'S" Formula.,A continuos flashing window with which title is C:Windows\System32\cmd.exe, and has the following message: The syntax of the command is incorrect.,Acrobat compatibility issue and you tube problems____,ActiveX on IE 9 not loaded

No comments:

Post a Comment