Search results

Hi folks, I have been going crazy for an hour now trying to figure out how to ADD SERIES LINES. Excel 2013 helps has zero information on it, and google/bing searches come up with nothing. Unbelievable. Anyone know how to add series lines in excel 2013 on a 100% bar chart? Raesu

Hello, I'd appreciate some advice on my attempt to format data labels the same way each time my VBA sub changes a charts data range (using VBA because the # of series changes). Conceptually I put the code together below but I can't figure out the correct structure for access the datalabel...

Hello, I'm using an array formula to populate an axis of a chart based on time period: ' {=CHOOSE($A$39,{"Jan","Feb","Mar","Q1"},{"Apr","May","Jun","Q2"},{"Jul","Aug","Sep","Q3"},{"Oct","Nov","Dec","Q4"},{"Q1","Q2","Q3","Q4","YearTotal"})} ' I'm trying to put a number along with the...

Thanks for any help on this. I'm working with some survey data on market share and could use some advice. The pivot table is easy enough, but the challenge I'm facing is that I have some quantity data to blend in, but not sure how. Here's a simplified data set: http://sdrv.ms/T1DQpL The...

Hello, Sometimes my dashboard is throwing an odd error on open. After "recovery", my freeze panes is removed, and I can see headings and gridlines (which I usually hide). Other than that it seems the dashboard is fine. I use some mild VBA to show/hide charts, and change formatting of cells...

Hello, I've been using a revenue dashboard for a while now, with about 10 named ranges and a sheet full of dynamic tables to power charts. I copied the dashboard, and replaced all the raw data with order data, and voila the revenue dashboard is now an orders dashboard. I'm trying to...

Hello, Surprisingly I couldn't find an article or forum posts on this topic. I got some clues from other sites but can someone validate this to make sure it makes sense? I'm using SalesForce IDs (different IDs can vary by the case of a letter) so I'd like to remove any lines with duplicate...

Hello, I'm trying to map out queues in SalesForce.com that give leads to sales reps. Reps have overlapping regions by state, and I'm struggling trying to find a logical solution to establish which reps belong to which queues (they can belong to more than one). I can't post anything on...

I was wondering if anyone had some opinions on this software. I'm looking to use it for organizing campaigns throughout the year in different areas, but using the trial I'm finding the software is actually pretty complicated even for someone comfortable with Excel. Any reviews? Should I...

Hello, I am intermediate-skilled with lookup formulas, VBA, SumProduct etc. but the project I'm on now is a different beast. I need to build transaction maps, so of a large table of data, I'd like to pull a smaller table for a quarter. Basically this is the step I can't figure out a great...

Hello, I'm using sumproduct to summarize some data from a larget table. The formula works great for everything EXCEPT my May data?! =SUMPRODUCT(--(PlanRegion=$B17)*--(PlanMetric=$C17)*--(PlanMktProd={"A","B","C","D"})*Plan!H$2:H$141) The column H is returning a #VALUE where everything...

Hello I have been trying to make a SUMPRODUCT formula to check if one line of data is exactly the same as another in my list. I have tried many variations, read thru the forensics post, but this formula is still giving me some difficulty to fully wrap my head around :( Here is one of my...

Greetings, This code highlights "Else" and says "Else without If". I am always running into little issues with If, Then statements, and it seems every time I do it I have to spend 15 minutes playing around with it until it works. No success this time :( It is comparing values from 2...

Hello, I currently have a table of variances shown by data bars. Green for positive, red for negative, applied by the stock Excel data bars feature in conditional formatting. These work great, however sometimes when the variance is 0 for all cells, some random cells will have a green or...

Hi all, My question can basically be simplified to asking the difference between a couple ways of writing code, which seem identical to me but one works and one does not. Adding a field called "User Id" to the table, Excel usually makes this a sum because it is all numbers. However...

I recently created a dashboard and pasted several tables as linked pictures (column and row width just were not allowing me to get where I wanted). It looks great but scrolling is just about terrible sometimes. Usually if i scroll down with the mouse it refreshes every second for a few...

I have been trying to get the results of a TextToColumns function filled into an array, turn it into a vertical array, then fill a column with those values. Temporarily I have opted to use the function, fill out a horizontal range, then cut and tranpose that range to where I want it. Just to...

Hello all, I'm making a pretty large workbook with over 20 worksheets, and would like to have different sets of worksheets show depending on which option button is selected on the main sheet. I have done this, but it is very inefficient and difficult to update when new sheets are added...