Hide Text Box On Embedded Chart

Mar 27, 2008

I have a workbook with two worksheets. On the second worksheet I have placed a chart, in which several shapes (text boxes) have been added manually. With the help of a TickBox in a UserForm on the first worksheet one can hide / unhide one of those shapes (on the second worksheet). By using the Macro recorder I finally came to this code fragment:

Application.ScreenUpdating = False
Worksheets("Second One").ChartObjects("Chart 41").Activate
ActiveChart.Shapes("Text Box 4").Visible = False
Worksheets("First One").Activate
Application.ScreenUpdating = True

Obviously another part of the code is used to make the shape visible again. roblem: The screen flickers. And I want to be able to do this without flickering. Searching Ozgrid revealed that the use of "Activate" makes the screen flicker. Hence, my question: How can I hide / unhide a shape (textbox) in a chart on another worksheet without of using "activate"? r: Any other way to hide / unhide a shape (textbox) in a chart on another worksheet without flicker?

View 2 Replies


Find The Embedded Chart Object Name?

Nov 10, 2008

Is there a way to find the embedded chart object name?

View 9 Replies View Related

Moving Embedded Chart Series Via Mouse

Apr 2, 2007

I have an embedded chart with a data series and a horizontal line that changes position (y-intercept) by values entered into a textbox. To make the process more user friendly, I would like to allow the user to select this horizontal line and reposition it inside the chart with the mouse. The new y-intercept of the line should then be displayable (textbox, cell, whatever). From what I have read on Peltier's site, I will definitely need to write a new class. Classes in VBA is not something I am particularly familiar with..

View 5 Replies View Related

Identify Correct Embedded Chart With VBA Macro

Oct 8, 2008

I have several charts embedded in a worksheet, and I would like to use the ChartObjects Method in VBA on some of them. That requires knowing the index number of the charts I want to work with. Where/how do I get that? (For example, in the VBA Project Explorer window the only listed objects are sheets. Is there an object explorer with a chart list?)

View 2 Replies View Related

Sheet Names As Embedded Chart Titles

Jan 9, 2008

I have a spreadsheet that has multiple sheets and each sheet has a graph, at oresent if i have to add a new sheet and graph i copy the last sheet, rename the tab then off we go, but i alway have to remember to also change the sheets graph title. is a mechanism so that if I change the Sheet Tab name then the chart will use the sheet tab as a chart title.

View 2 Replies View Related

Rename Embedded Active Chart Sheet Name

Jan 17, 2008

For example, a cell on the screen is blank. When the page is printed, the "blank cell" has printed text.

I checked "format cells" and it shows word wrap, merge cells, and left to right.

I was told to "un-merge" the cells. I did that and I still have the problem.

The color on all the cells is OK at a blue shade. When I look at print preview the cells are blank, but when the sheet is printed, the text shows.

Also, it looks like there are 2-3 cells inside the main cell.

I hope I have explained this properly, it is not easy to use the correct language to describe since I am not very good at using Excel.

View 4 Replies View Related

Long Text String With Embedded Variables

Apr 17, 2007

I am trying to automate a report writing spreadsheet in which the text never changes in the cell (up to and over 50 words long).

Is there any way in which the figures within that text could be linked to another cell and change accordingly.

For example: a particular cell might contain the following which never changes apart from the figures:

"the performance of the fund was (B5) followed by a change in the index of (B6)...........the performance of the irish stocks was (A19) etc etc."

I know something can be done in formatting but for very long text would this be impracticle?

View 5 Replies View Related

Pie Chart - How To Use Hide Values But Not Show In Chart

Dec 17, 2013

I have created a pie chart showing top 10 best selling categories. However, on this pie chart, I want %age of overall sales to be shown.

At the moment say I put in the following

Catalogue 1 100
Catalogue 2 98
Catalogue 3 92
Catalogue 4 85
Catalogue 5 84
Catalogue 6 75


I add Data Labels and select the percentages. This shows at Cat 1 having 12.5% of the sales (100 of 800 sales), Cat 2 having 12.25%, and so on..... However, what you don't see is the following data:

Catalogue 11 60
Catalogue 12 58
Catalogue 13 57
Catalogue 14 57
Catalogue 15 56

So based on 1,088 sales, Cat 1 at 100 is actually only 9.19% of TOTAL sales.

I understand what is happening, the chart is giving the percentage based on the data inputted into the chart.

I did consider adding an 11th category to the chart, which was the total of Catalogues 11-15. Whilst this does give a more accurate percentage figure (as now all sales have been inputted), it makes the chart look ****

Is there a way of either adding the 11th category, and then "hiding" it, so that the chart doesn't display it, but uses it's value to calculate Catalogues 1-10s percentage?

BTW: The reason I ask is that I could be dealing with anywhere from 30 to over 100 catalogues. So it's not ideal showing the others in 1 chart.

View 1 Replies View Related

Hide Chart Sheets

Jul 19, 2008

I would like to hide all worksheets and chartsheets in a workbook. I use

For Each sh In Sheets
sh.Visible = xlSheetVisible
Next sh
but I think it breaks down for chart sheets. Any solutions?

View 9 Replies View Related

Hide A Chart Which Is Its Own Worksheet

Dec 18, 2007

To hide a worksheet upon open I use: wsSheet.Visible = xlSheetVeryHidden. What do I use to hide a chart which is its own worksheet?

View 3 Replies View Related

Hide Zeros On Pivot Chart

Mar 21, 2008

I have a PivotTable linked to a Bar Chart. (see attached JPG for example)
I do not want the 0% values to show in the chart at all but I do want to see all of the other percentages. I have been able to hide these values in the PivotTable itself by Conditional Formatting or custom number formats but they still show up in the chart!? how I can get the 0% values to be hidden or not show on the charts at all? I don't want to have to do this manually for every 0% that shows because the data changes daily dynamically. A VBA or Macro solution would be preferred.

View 3 Replies View Related

Selectively Show Or Hide Chart Series

Feb 27, 2013

I have a chart with multiple series which I am hoping to show/hide based upon a particular value attached to each series. I was therefore wondering if it was possible to extend the Series object class so that I could have something along the lines of a "Series.specialvalue" property which I could assign and then check to decide whether to show or hide the series?

View 1 Replies View Related

Hide Minus Values On Y-axis On A Chart

Jun 25, 2007

column chart displaying various pieces of data.

At the top of my worksheet I have a combo box which allows you to select a local authority name; and all relevant information in the worksheet is highlighted (using conditional formatting, extra series in charts to make relevant points highlight in red, etc).

I've added a series to the chart and changed it's type to line - then with the data labels positioned beneath the points on the line I can get conditional formatted x category labels - all outlined here: [url]

Because my x category labels are fairly long I've had to give them an orientation of -90 and make the minimum y-axis value equal to -200 to give enough room beneath the chart to fit the text in.

As I said above, the values below 0 are just there to provide space at the bottom of the chart, so my question is: is there a way to hide these negative values? I'm sure I've done it before, but can't remember how - I thought maybe a custom number format of #;[White]# would work, but it just inverted my text (white text on black background).

View 11 Replies View Related

Hide & Show Chart Series Via CheckBox

Aug 25, 2004

Attached is a simple chart and I would like Users to be able to tick a checkbox to show/don't show 'available' series. In the example If the User clicks for Group 1, then only Customer A's data is shown. If Only Checked Group B, then Customer B and C are displayed. If both boxes are checked, then all three Customer's figures will show. (Hopefully depending on what's ticked, the chart's scale would adjust accordingly)

View 3 Replies View Related

Conditionally Hide Chart Axis Labels

Sep 4, 2007

Is it possible to hide some of the number labels on an axis; e.g. in on the chart below to hide the X-axis label 96? Or only start numbering from 97 while the chart displays from 96. Auto Merged Post;Well I have a solution to hiding the first value on the excel X axis values labels just using a custom number format;


but is there anyway of formating more than a couple of the number labels individually?

View 2 Replies View Related

Excel 2010 :: Hide Zero Values In Pivot Chart

Nov 29, 2011

Excel 2010 how to not chart zero values in a Pivot Chart?

View 1 Replies View Related

Embedded Browser

Feb 11, 2006

I would like to embed a chart that updates from the web into my spreadsheet. This is it here:


View 9 Replies View Related

Hide Text Box?

Feb 11, 2014

Is is possible to hide a text box?

View 3 Replies View Related

Embedded Bigger Than Smaller Than-IF

Jul 13, 2009

The jist of the problem is that employees are paid their normal wage up untill 37.5 hours of work. From 37.5 to 40 hours of work they are paid 1.5 times their wage. Any hours over 40 are paid at 2 times the regular wage.

So i need a formula that can work out their total pay. Im not sure what i could put in a dummy document to help you since it would just be one cell for their hourly wage, one for their hours worked and then one for the calculation. so you can reference any cell as an example and assume 6 as hourly rate

View 3 Replies View Related

Import From PDF Embedded On Web Page?

Dec 15, 2009

Working on automating a data update process for my department (well, for the Italian speaking analysts anyway). I'm trying to import data from an embedded PDF to my Excel 2007 worksheet - I only need the data on the PDF, but if the whole screen can be scrapped I can clean it up in my code.

Any ideas if/how I can do this?

View 12 Replies View Related

Embedded Macros In New Solver

Feb 12, 2012

Can embedded macros be found within the new Solver and how would you make the changes you need in VBA with different constraint analysis?

View 3 Replies View Related

Attaching Already Embedded PDF To Email?

Jan 14, 2014

My "Drawing" is embedded on Sheet1, later on in Sheet12 I click a button that'll send an automatic email to a user. I want to attach the embedded PDF onto this email if it is at all possible??

Dim Drawing As Object
After I've declared my variables I've tried setting the variable "Drawing" to the object, this is where I'm encountering my errors mainly "Type Mismatch" or Object Variable not set...

Sheets("Menu").Visible = True
Drawing = Sheet1.Shapes.range(Array("Drawing"))
Selection.Verb Verb:=xlPrimary
Sheets("Menu").Visible = False
At the bottom of the code, this is where i pull in the object

.To = Sheet12.range("L8")
.CC = ""
.BCC = ""
.Subject = "Arrange P&D Request"
.htmlbody = strbody & vbNewLine & Signature
.Attachments.Add ("Drawing")

View 9 Replies View Related

IF Function Using Embedded Checkbox

Jan 4, 2007

I need to create a formula that will calculate a total if someone checks a certain box. (Each check box is associated with a cost. When people check the correct costs, the bottom should total the costs checked.)

View 9 Replies View Related

Embedded If Statement In Cell

Jan 12, 2009

i want to make and if statement in a cell that does the following:

if "J8 > 10" then fail
if "5

View 9 Replies View Related

Set Color Of Embedded Labels

Nov 21, 2006

I have a worksheet with Labels (from the "Control" Toolbox) embedded and I want to read and/or set the BackColor value in VBA. I can't figure out how to accomplish this when they're embedded on a sheet like this.

View 2 Replies View Related

Looping Through Embedded Charts

Feb 28, 2007

I have a worksheets (named Graphs) that contains 12 pie charts, 8 column charts and 4 line charts. I would like to create some VBA code to loop through all these 24 embedded charts and modify only the pie charts. I'm OK with the code to do the modification (which is to set their plot area size and also to delete the title), however, I have no idea how to do the initial loop to select only the pie charts. I'm sure there's a much better way then hardcoding in each of their chart names.

View 2 Replies View Related

Hyperlink To Embedded Object

Mar 28, 2008

I'm using Excel 2003 and have a spreadsheet that I want to distribute to a handful of people around the globe.

I want some cells in the page to link to various PDF files which I need to distribute with the worksheet.

I can embed the PDF files no problem, but I need each link to the embedded objects to take up no more vertical space than one row of text (without an Icon) - ie I need to be able to access the object through a "hyperlink style" item.

I can't figure out how to do this, as the hyperlink function does not seem to permit linking to embedded objects.

View 4 Replies View Related

How To Hide / Display Text

Feb 13, 2013

I am trying to hide/display text by using form fields. I swiped the idea from a spreadsheet I obtained from a vendor and thought I would extend it to suit my purpose.

When I check the box for "table one", I'd like for the data that I have associated with it to display. When I uncheck the box, I would like for that data to be hidden. The goal is to be able to choose one data source and see at a glance which fields come from that source and what their names are. The formulas that currently exist for the cells in column I do a nice job of putting text in a field when the box is checked, but I don't want to have to rewrite the formula in the cell if/when the source of the data changes. It's a lot of long schema/table/field names. Maybe that's the only way, though...

I scrubbed and mocked up column J to try to demonstrate. It's sorta color coded.

And it might be that using form fields is not the best way to hide/display text based on source type.

View 2 Replies View Related

Show Row If Contains Text Hide All Others?

Mar 30, 2014

get my code to work.

I have a sheet with a dropdown box in cell "J1" which is meant as a 'Show only rows containing this value'.

Column Q, from row 3 downward has a pick box which lists the same values as the "J1" drop down box, but uses code to combine whats chosen with commas. An example of what is in a cell in column Q is "SeaHawk, BlackHawk, Squirrel, MRH", where cell J1 would be either "SeaHawk" or "MRH" or something completely different.

I need to only show rows, with text in column Q containing the smae text as J1.

View 8 Replies View Related

Hide Lines Containing Certain Text

May 2, 2008

I have an automated formula which i have to fill down to line 250, yet in the majority of cases i only need it to say line 20, and as a result i have loads of lines stating "Not Found" has anyone got a way to hide any lines containing either "Not Found" or a blank cell??

View 9 Replies View Related

Copyrights 2005-15 www.BigResource.com, All rights reserved